Forum Discussion
Interactive filtering treemap
Hello,
my first post.
I am using two charts. One bar and one treemap chart. When filtering interactively by pressing one bar in the chart, the treemap's content adopts to this action.
The treemaps ractangles keep the same size (without filtering) and the filtered content is shown as part of the original size.
Is it possible, to let the treemap fully adopt to the filtered data? No transparent part in treemap, but completely filled with the now selected/filtered data?
Thanks in advance
Two screenshots might be helpful:
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/
6 Replies
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.