CODEWITHSUNDEEP
sqlpowerbireportingbusiness-intelligence
Stan
Stan

Reputation: 21

Different value in PowerBi chart per drillthrough level

A productivity chart consists of a three level date hierarchy (1) year, (2) month, (3) week as Axes. Drilling down the chart over the date hierarchy, I would like to display a different measure per drillthrough level. Such that, drillthrough level (1) date[year] displays measure A, (2) date[month] displays measure B, (3) date[week] displays measure C.

Appreciate any help on this issue a lot.

Thanks in advance!

Upvotes: 0

Views: 1225

Answers (2)

Stan
Stan

Reputation: 21

The following appeared working for me and provides a unique measure per drillthrough level:

Measure_PAR = IF(ISFILTERED(Query1[Date].[Year]) && ISFILTERED(Query1[Date].[Month]) && ISFILTERED(Query1[Date].[Week]), Measure C ,IF(ISFILTERED(Query1[Date].[Year]) && ISFILTERED(Query1[Date].[Month]), Measure B ,IF(ISFILTERED(Query1[PRODUCTIONDATE].[Year]), Measure A)))

Upvotes: 1

CR7SMS
CR7SMS

Reputation: 2584

This is not possible in the traditional drill-down options using hierarchy. You will just be able to drill-down into the next level of hierarchy for the same measures. But, you can do a version of your desired output using Cross-report drill-through. You will have to create 3 report pages in this case, one for each level and then you can use the drill-through to report option to get the desired result:

https://learn.microsoft.com/en-us/power-bi/desktop-cross-report-drill-through

This may not be the exact solution you are looking for, but I believe this is the best possible solution for your request. Hope this helps.

Upvotes: 0

Related Questions