Forum Discussion
Conditional formatting logic keeps reverting back to percent/number
Hi leolapa_br , look how its easy when we interact with a dashboard, what you need is just edit interactions between any visual including treemap to filter your column chart.
Select treemap visual, go to format, click on edit interactions and in your column chart choose filter as shown bellow:
When i click in treemap value to filter, its now showing correct values.
Hi Bibiano_Geraldo, I've done as you suggested and created a sanitized PBI in English so I can share. Please find the OneDrive link below:
While doing that I found out that the conditional formatting issue only persists when the filtering is done via a treemap visual featured on the dashboard next to the column/line chart that I've been trying to fix. If the filtering is done via a slicer then the conditional formatting occurs without a problem. The sequence of screenshots below depicts what I mean...
This is the dashboard mock up with no filters applied:
Now the dashboard mock up filtered to a single store via slicer. No conditional formatting issues on neither the matrix nor the chart:
And finally the dashboard mock up filtered to a single store via the treemap visual. The matrix still presents no conditional formatting issues, but the chart's conditional formatting now is wrong:
What puzzles me is why the problem arises when filtering with the treemap, and why the problem only shows up at the chart while the matrix is still OK. Questions I don't have an answer for!
Hi leolapa_br , look how its easy when we interact with a dashboard, what you need is just edit interactions between any visual including treemap to filter your column chart.
Select treemap visual, go to format, click on edit interactions and in your column chart choose filter as shown bellow:
When i click in treemap value to filter, its now showing correct values.
I really appreciate your help on this one Bibiano_Geraldo!
When I realized that it had something to do with the fact that I am filtering via another visual I suspected the solution to the problem would be something easy but in an area I'm not entirely familiar with, and that's the case with editing interactions. Lesson learned!
Happy it worked, leolapa_br !