Interactive filtering treemap

[jpodBerlin]

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:

[Anonymous · Accepted solution]

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.

[Anonymous]

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

[jpodBerlin]

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

[jpodBerlin]

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.

[Anonymous · Accepted solution]

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.

[jpodBerlin · Accepted solution]

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/

[Anonymous]

@jpodBerlin

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.