Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, I'd like to create a filter measure to show the current month and upcoming 3 month data in the power BI graph. Yet what I created turns the graph blank. And I doubt whether the data from several years on the same month number would be aggreated. Grateful to have your help.
Below is my measure:
Solved! Go to Solution.
Hi @rachelbi
I missunderstood your question. I did not able to to get full proof solution but this will help or you can work around a bit and get the reuqired calcualtion
1. i have create the new table using this
and from
month year filed click show item with no data
this is work around, this might be not 100% full proof solution but hope you got the the concept to approach solution
Regards
Hi @rachelbi
I have taken daily level dummy date data.
Now, create a new table with date by using distinct(date column)
once you create new table create new measure like this
this is what got as an output.
If you since iabe only single date per month so in April 30 rows in may 31 and so on
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem
Regards
Thanks @qqqqqwwwweeerrr , i would like to make the graph for current month to upcoming three month, i.e. Apr 2024 to Jul 2024. Given that I only have Apr data at the moment, wonder how to make the graph to show May, June & July in x-axis even though they are empty right now?
Many thanks again
Hi @rachelbi
I missunderstood your question. I did not able to to get full proof solution but this will help or you can work around a bit and get the reuqired calcualtion
1. i have create the new table using this
and from
month year filed click show item with no data
this is work around, this might be not 100% full proof solution but hope you got the the concept to approach solution
Regards
thank you so much! I got it based on your logic 😊
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
109 | |
105 | |
73 | |
71 |