Share
Report
1,091Hello All,
I have been trying hard to suppress null values on the model driven chart or I dont want to show the equipment category with blank/null values on the chart.
Here in the chart below, I dont want show null values for the "Laptop" or any other equipment if the company is not assigned that equipment.
I have checked the blog post https://docs.microsoft.com/en-us/power-apps/developer/model-driven-apps/understand-charts-underlying-data-chart-representation#supported-numeric-format-for-charts-in-unified-interface and https://crmchartguy.wordpress.com/2013/06/24/labelformat-cheat-sheet/ and found you can format labels and suppress negative or 0 values. But here I just dont want to suppress the 0 values. I would not like to show the null values or small bars of that equipment at all in the chart.
I have tried customizing the chart xml like below but found its only suppressing 0 values but not null values.
<Series ChartType="Column" IsValueShownAsLabel="True" Font="{0}, 9.5px" LabelForeColor="59, 59, 59" CustomProperties="PointWidth=0.75, MaxPixelPointWidth=40" LabelFormat="#,0;(#,0);' '" />I just want to show the bars which have values 1 or more in simple terms. Let me know if its possible at all. Thank you so much in advance.
Best Regards,
Ramesh
All responses (
Answers (
