Forum Discussion
Need help with Conditional Formatting in Pie Chart or alternative workaround
Hi All,
There is a table with two columns.
Manager | Sales Revenue
A | $10000
B | $11000
C | $12000
D | $13000
E | $14000
F | $15000
My requirement is to create a pie chart showing the distribution of total sales revenue by Manager.
I want to apply conditional formatting to the chart.
What I mean by that,
- I have a slicer with the manager name list/drop down
- When I select the manager in the slicer, the pie chart should still display the distribution of total sales revenue among Managers. But highlight the segment of the manager selected. (It can be highlight or it can also be one shade color of that manager segment and different color shade for all other manager segments).
Is there a way to achieve this?
3 Replies
pls try this
you can change the visual interact to highlight.
Thanks ryan_mayu
With interaction with another visual, selecting in one visual(for eg: column chart), it is able to highlight the segment in pie chart.
But couple of issues are:
- We have to select in that visual to interact with pie chart. Not like selecting the slicer interacts with pie chart to highlight the segment.
- When we select the other chart, even though it highlights the segment of the pie chart, the rest of the segments are shown as 0%, which is not correct.
PFA. screenshots
i am afraid that is by design. let's see if any one else can provide better solution for this
