Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello,
I have a calendar table with a column, 'date', of simple dates . I dropped 'date' into a slicer and then added a measure to a secondary table based off the user selected calendar table 'date'.
Measure as follows: As Of Date = CALCULATE(MAX('Calendar Table'[Date]),ALLSELECTED('Calendar Table'[Date]))
Then I use this user selected date in another measure, a date diff calculation, to determine the # of days until an event occurs. Finally, I have a last measure which lables the dynamic date calculation as either "fewer than 30 days" or "more than 30 days". This works great when I drop the measure into a table as I can see for each record, or property, whether an event will occur in fewer than 30 days or more than 30 days.
QUESTION: Users want to see the results aggregated in a donut chart. Example, 26 properties labeled "fewer than 30 days" and 82 properties labeled "more than 30 days". How can I make that happen and have the result dynamically driven by the date a user selects?
Thanks in advance!
......just learning DAX here, please be gentle : )
Solved! Go to Solution.
Hi @jrieman ,
You may have to put your measure into a calculated column to allow there to be a record of how many instances of the two conditions. Or you may be able to create a measure using VAR and create a virtual table which will allow you to do the same thing. You would probably need to create two measures, one that returns the more and the other the less. This is pretty general, but working with what you gave us.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Hi @jrieman ,
You may have to put your measure into a calculated column to allow there to be a record of how many instances of the two conditions. Or you may be able to create a measure using VAR and create a virtual table which will allow you to do the same thing. You would probably need to create two measures, one that returns the more and the other the less. This is pretty general, but working with what you gave us.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
12 | |
11 | |
10 | |
9 |