7
P

Create table in powerbi for disconnected slicer

Power BI Ideas Admin on 9/17/2015 8:52:34 PM
7
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
STATUS DETAILS
Needs Votes

Comments

P

P

RE: Create table in powerbi for disconnected slicer

Austin Senseman on 7/5/2020 10:38:12 PM

This is completed

P

P

RE: Create table in powerbi for disconnected slicer

Power BI User on 7/5/2020 10:06:04 PM

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

P

P

RE: Create table in powerbi for disconnected slicer

Power BI Ideas Admin on 7/5/2020 10:05:14 PM

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

P

P

RE: Create table in powerbi for disconnected slicer

Bertrand d'Arbonneau on 7/5/2020 10:05:07 PM

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