Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

Treemap Filtering not working

Hey guys, 

 

I'm new to Power BI and I'm trying to build a Power BI Report for my team.

I want to use a treemap as a "filter" so that whenever we click on a value we can see the corresponding "Forecast vs Actuals" of the value we selected.

 

However, I'm running into an issue where the visualization doesn't update accurately when selecting 1 of the 5 values (note that it works as intended for the remaining 4...)

 

I have no idea why this happens and it's driving me nuts, could you help? 

 

Here are 2 screenshots (all fictional data). When selecting "ERP" the bar chart moves and updates accurately but when selecting "W&A" the numbers get stuck and don't update. I have also included a screenshot of what "W&A" should actually look like (i tried with a normal slicer and it updates accurately but i'd really rather use the treemap as it's way cooler).

 

ERP Selection using treemap (OK)ERP Selection using treemap (OK)W&A Selection using normal slicer (this is how I need it to look when selecting W&A via the treemap)W&A Selection using normal slicer (this is how I need it to look when selecting W&A via the treemap)W&A Selection using treemap (Not OK)W&A Selection using treemap (Not OK)

Status: Investigating

Hi @RafaelSantos 

 

 It is not the general usage of Treemap visual. It is usually used to display hierarchical data. I have tested this issue based on your description in October 2021 Power BI Desktop and November 2021 Power BI Desktop.

If I click on items in Treemap visual, cross-filters work well.

vcazhengmsft_0-1639361706278.png

 

I find that I only get this issue when setting filters for Treemap in Filters Pane. May I know whether you get this issue under the same circumstance as me?

vcazhengmsft_1-1639361706283.png

 

Also, I do suggest you locking Selector filter in Filter Pane and only cross-filter your data by clicking on items in Treemap visual if you really want to use Treemap visual in that way.

vcazhengmsft_2-1639361706284.png

 

 

Best Regards,

Community Support Team _ Caiyun

Comments
v-cazheng-msft
Community Support
Status changed to: Investigating

Hi @RafaelSantos 

 

 It is not the general usage of Treemap visual. It is usually used to display hierarchical data. I have tested this issue based on your description in October 2021 Power BI Desktop and November 2021 Power BI Desktop.

If I click on items in Treemap visual, cross-filters work well.

vcazhengmsft_0-1639361706278.png

 

I find that I only get this issue when setting filters for Treemap in Filters Pane. May I know whether you get this issue under the same circumstance as me?

vcazhengmsft_1-1639361706283.png

 

Also, I do suggest you locking Selector filter in Filter Pane and only cross-filter your data by clicking on items in Treemap visual if you really want to use Treemap visual in that way.

vcazhengmsft_2-1639361706284.png

 

 

Best Regards,

Community Support Team _ Caiyun