Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    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

    Austin Senseman 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

    Power BI User 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

    Power BI Ideas Admin 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

    Bertrand d'Arbonneau 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"})