Forum Discussion
Drill down measures
I have a measure value which is calculated as measure1+ measure 2+ measure3
And measure1 is aggregate of 3 sub categories and measure2 has 4 subcategories. I want to represent these values in sunburst /drill down pie chart as categories and subcategories.How can I do that?
Thanks!
hi, umanbr
After my research , I'm afraid it couldn't achieve in Power BI for now.
although the measure is calculated as measure1+ measure 2+ measure3
But it's essentially one formula,
for example:
Measure =measure1+ measure 2+ measure3
Measure =COUNTA([Value]) + Max([Value]) + Min([Value])
How do you dirll down this measure.
But as a workaround, you could use Bookmark to get a similar effect, here is a blog for you refer to:
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
For one bookmark, it shows Measure with visual
and another bookmark, it shows measure1, measure 2, measure3 with visual
Then you use bookmark for "Drill down"
Best Regards,
Lin
1 Reply
v-lili6-msftCommunity Support
hi, umanbr
After my research , I'm afraid it couldn't achieve in Power BI for now.
although the measure is calculated as measure1+ measure 2+ measure3
But it's essentially one formula,
for example:
Measure =measure1+ measure 2+ measure3
Measure =COUNTA([Value]) + Max([Value]) + Min([Value])
How do you dirll down this measure.
But as a workaround, you could use Bookmark to get a similar effect, here is a blog for you refer to:
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
For one bookmark, it shows Measure with visual
and another bookmark, it shows measure1, measure 2, measure3 with visual
Then you use bookmark for "Drill down"
Best Regards,
Lin