Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Filter visual based on multiple criteria

Hi friends,   I'm trying to create a bar chart with sales volume by category. The values I want to present is the sales volume of a specific category and categories with top 3 sales volume. However...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    Please new a measure like:

    Measure = 
VAR __top3 = TOPN(3,ALLSELECTED('Table'[Catagory]),CALCULATE(SUM('Table'[Sales Volume])))
VAR __result = IF(SELECTEDVALUE('Table'[Catagory])="grocery"||SELECTEDVALUE('Table'[Catagory]) IN __top3,1)
RETURN
__result

    Then select the visual and configure the filter like this:

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

Please new a measure like:

Measure = 
VAR __top3 = TOPN(3,ALLSELECTED('Table'[Catagory]),CALCULATE(SUM('Table'[Sales Volume])))
VAR __result = IF(SELECTEDVALUE('Table'[Catagory])="grocery"||SELECTEDVALUE('Table'[Catagory]) IN __top3,1)
RETURN
__result

Then select the visual and configure the filter like this:

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Anonymous's avatar
Anonymous
Not applicable
3 years ago

amazing! thanks!