March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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!
Solved! Go to Solution.
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
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
@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-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |