nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Hide dynamically a Pie Chart depending on series value

StÃ©phane

Hi,
 
It is forbidden - because impossible in the real world - to show a negative value in a Pie Chart.
 
So I am looking for a solution to hide a Pie Chart if it has a negative series. And replace it by a Bar Chart.
 
So I need to test each series value and if one is negative, hide the graph. 
 
I searched on the forum all the day and I did not find. 
 
Could you please help me?
 
(My idea is to have the 2 graphs - one Pie and one Bar - and show the right one depending on the data).

Find more posts tagged with

Comments

pricher

Hi,
 
Because you need to test the series value before the pie chart is generated, you best option is to create a the chart inside a table and bind the chart to the container's data.
 
In the attached example, the sample data set will return negative values for product lines when the buyprice is subtracted from 50. (You can subtract from 80 if you want to get only positive values and test the display of the pie chart).
 
The table is grouped on product line and contains an aggregation that sums up the price column per product line (you can look at the binding for the table to find the aggregation definition)
 
The table has only a table footer that contains a pie chart and a bar chart. The Visibility attribute of the bar chart is set to hide the chart when the aggregation is never negative. The Visibility attribute of the pie chart is set to hide the chart when the aggregation is negative.
 
There are probably other ways to do it depending on your business case, but right now, you have an option!
 
P.

StÃ©phane

Hi,
 
Excellent, thank you,
 
Best regards,
 
StÃ©phane.

StÃ©phane

Hi, 
 
It did not work with my code, I searched and in fact your tip does not work neither.
 
If you filter in the DataSet the PRODUCTLINE Motorcycles, you will have only one group with a negative value: Trucks and Buses, and the Pie Chart appears.
 
In fact, your example works because the first group - Motorcycles - is negative, if the first group is positive, that does not work.
 
StÃ©phane.

pricher

Sorry about that... Here's one that should work. I have added a new aggregation at the table level to find the minimum value of the already computed aggregation. The test for visibility on the charts is now based on that new aggregation, i.e. if the minimum value is negative, don't show the pie chart.
 
P.

StÃ©phane