cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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:

 

treemap filter 1.PNGtreemap filter 2.PNG

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Anonymous
Not applicable

Re: 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.

 

 

 

 

View solution in original post

Highlighted
Frequent Visitor

Re: Interactive filtering treemap

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/

View solution in original post

6 REPLIES 6
Highlighted
Anonymous
Not applicable

Re: Interactive filtering treemap

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

Highlighted
Frequent Visitor

Re: Interactive filtering treemap

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

 

 

Highlighted
Anonymous
Not applicable

Re: Interactive filtering treemap

@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.

Highlighted
Frequent Visitor

Re: Interactive filtering treemap

treemap filter 3.PNG

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.

Highlighted
Anonymous
Not applicable

Re: 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.

 

 

 

 

View solution in original post

Highlighted
Frequent Visitor

Re: Interactive filtering treemap

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/

View solution in original post

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors