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 spreadsheets but don't know the best way to format them. I currently can get a card to display today's date, and the daily topics by today's date. However, I can't get a card to show the weekly or monthly topics. Any help would be appreciated!

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

     

2 Replies