Forum Discussion
Interactive filtering treemap
That's weird. I can get it to work on my PC. I mean I can press the bar chart and get the filtering mechanism on the treemap.
A pie chart is still a good solution nevertheless.
Don't forget to accept a solution and give kudos.
Meanwhile I've found the solution. This is obviously included since november 2015.
Edit interactions.
https://powerbi.microsoft.com/en-us/guided-learning/powerbi-service-visual-interactions/
Hi jpodBerlin
As far as I'm aware, you can't do this per se.
You can try with this measure: and plot it in the tree map:
Sum Value = IF(HASONEFILTER(Table[Category]);CALCULATE(SUM(Table[Value]);ALLEXCEPT(Table;Table[Category]);SUM(Table[Value]))
Let me know how it goes.
Best,
Martin
Hello Martin,
thanks for the swift answer. I've tested it.
However, it shows an error (I try to translate in English). I hope I've transmitted the formula correctly.
"the function of type 'SUM' is used in a TRUE/FALSE expression, which serves as table filter expression. this is not allowed'
But the answer, it is generally out of box possible is helpful.
Matthias
I messed up a paranthesis. Try this:
Sum Value = IF(HASONEFILTER(Table[Category]);CALCULATE(SUM(Table[Value]);ALLEXCEPT(Table;Table[Category]));SUM(Table[Value]))
Let me know how it goes.
Hello Martin,
the measure is now valid. However, it is the same result (image: left with new measures, right the original object).
The problem is, the numbers have to adopt to the filter expression (here: 2017), but interactive filtering from charts keeps the size and just provides subsets. So it is not so easy to identify relative changes.
I will recommend my colleague to use a pie chart. And after filtering to enlarge the filtered result. Not perfect, but here it is better to identify changes in relations. And there is still a table possible.
That's weird. I can get it to work on my PC. I mean I can press the bar chart and get the filtering mechanism on the treemap.
A pie chart is still a good solution nevertheless.
Don't forget to accept a solution and give kudos.