Forum Discussion

natsibley's avatar
natsibley
New Member
6 years ago

Measures and Slicers

I'm developing an economics report in Power BI.  It indicates whether individual items (rows in a table) are having a profit or loss.  I want the user to be able to select to show items showing a pro...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

natsibley 
There is a workaround if you want to make the category as a slicer, while main the measures to be dynamic.

1. create a table

2. create a new measure

 

Measure = IF(NOT(ISFILTERED('Table (2)'[Slicer])),[Category measure],IF([Category measure]=SELECTEDVALUE('Table (2)'[Slicer]),[Category measure]))

 

Pbix: https://qiuyunus-my.sharepoint.com/:u:/g/personal/paul_qiuyunus_onmicrosoft_com/Ebb79lXCS_tCn_-rQylRamgBNJ7zL-b-eThDo1SJlC5BWw?e=1Fd4Il 

 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • natsibley's avatar
    natsibley
    New Member
    6 years ago

    Thank you, that gets me the rest of the way there.  

     

    Is there a way to mark the combination of the two responses as the Solution?