Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm trying to design a dashboard with a drill through page. What I want is:
For example, my data could look like this:
In the Dashboard Page, I'd like to show this Bar chart:
I'd like to drill through on one of the bars and show a waterfall chart between this date and the previous date. For example, if I drill through on 02/28/2019, I want to see this:
I can't figure out a way to keep the previous date. I think I need to do something on the data side. But how?
Thanks.
Solved! Go to Solution.
@Anonymous - Please see attached pbix for one way to do it.
The following steps make up this solution:
Anyone?? Thanks!
@Anonymous - Please see attached pbix for one way to do it.
The following steps make up this solution:
Hi there,
Just a follow up question. In the dashboard page, I can't use the date hierachy to enable the drillthough function. Essentially at the end I want to see my x-axis like this, and the drill through waterfall chart show similar YYYY MM format:
Right now I have to make the x-axis in full date format (dd/mm/yyyy) to make it work.
I tried to create a year column and a month column in the Date Relationship table, then use the new columns as drill through filters. But it's not working.
Thanks!
@Anonymous - Please see attached. Needed to adjust the Measure a bit:
Altered Value =
var _date = LASTNONBLANK('Date'[Date],CALCULATE([Basic Value]))
return CALCULATE(
SUM('Values'[value]),
ALL('Date'),
'Date Relationship'[date] = _date,
USERELATIONSHIP('Date Relationship'[Mapping Date], 'Values'[date])
)
Thank you!
Thank you very much! It works for my situation. And thank you for the detail Power Query Steps.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |