Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
karo
Advocate V
Advocate V

Dynamic multi-selection of measures as a table slicer

Hi,

 

I am wonder if anyone knows how to set up dynamic slicer allowing multi-selection of mesures for a table (matrix)?

Any hints or useful links will be appreciated.

 

Regards,

Karo 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@karo , if you want to add measures as you click in the matrix I doubt that is possible. unless it is column values  or legend value in chart.

But you can change measures using measure slicer  https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@karo , if you want to add measures as you click in the matrix I doubt that is possible. unless it is column values  or legend value in chart.

But you can change measures using measure slicer  https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

Thank you @amitchandak  I was afraid that there is a limitation for Matrix 😞

vanessafvg
Super User
Super User

does this help at all?

 

https://www.thedataschool.com.au/danica-hui/switching-measures-and-titles-dynamically-in-power-bi/

 

if not can you give an example of what you looking for.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Hi @vanessafvg 

Thank you for the reply, however I am looking solution dedicated for table (matrix) and multi-selection of mesueres (for example measure A and B selected together). I am able to obtain such efect for charts, but not for tables.

 

Regards,

Karo

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.