Forum Discussion

hernandezl9651's avatar
hernandezl9651
New Member
4 years ago
Solved

Multiple Cards with different filters

I'm trying to create a dashboard that shows the following on seperate cards:   Today's Date Daily Topic  Weekly Topic  Monthly Topic   I have the daily, weekly, and monthly topics in different...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    Hi hernandezl9651 ,

    You could try to use slicer and selectvalue measure.

    refer the below:

    Measure = IF(SELECTEDVALUE(Slicer[Slicer])="A",MAX(test[Day]),IF(SELECTEDVALUE(Slicer[Slicer])="B", MAX(test[month]),MAX(test[week])))

    Visual:

    Depending on the slicer selection, the card returns the various data you want.

     

     

    And if question still not solved ,could you pls share you sample data and expected outputresult.Remember to remove confidential data.

     

     

     

    Best Regards

    Lucien

     

amitchandak's avatar
amitchandak
Super User
4 years ago

hernandezl9651 , You can create measure of visual level filter


Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8