Skip to main content

    Power BI

    New

    Create table in powerbi for disconnected slicer

    Vote (7) Share
    Power BI Ideas Admin's profile image

    Power BI Ideas Admin on 17 Sep 2015 20:52:34

    Disconnected slicers are very useful for building conditional measures. They sometimes require very simple tables (ex. two columns and three rows) I'd like to be able to create a simple table in PowerBI instead of referencing a datasource

    Comments (4)
    Power BI Ideas Admin's profile image Profile Picture

    11714d96 e626-4b4c-bfda-80a353201408 on 05 Jul 2020 22:38:12

    RE: Create table in powerbi for disconnected slicer

    This is completed

    Power BI Ideas Admin's profile image Profile Picture

    21ddd74e 326f-4b44-824f-71162a260207 on 05 Jul 2020 22:06:04

    RE: Create table in powerbi for disconnected slicer

    Hmm, guess this would be possible using the new Calculated Table feature. See the post from Alberto Ferrari about Transition Matrix on sqlbi.com

    Power BI Ideas Admin's profile image Profile Picture

    a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:05:14

    RE: Create table in powerbi for disconnected slicer

    Yeah BdA, I've used that before. It would be nice to have an easier way for less savy users.

    Power BI Ideas Admin's profile image Profile Picture

    bb453649 92fa-450a-a16d-63e4a234ea5f on 05 Jul 2020 22:05:07

    RE: Create table in powerbi for disconnected slicer

    you can actually do this with M code, but granted, this is not very user-friendly. Ex: Table.FromRows({ {1, 3}, {2, 4}}, {"a", "b"})