Skip to main content

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"})