Blank value visualized as 100% in the Clustered column chart.

[Pepok_14]

Hello, 

could you please help me to understand why blank value is visualized as 100% in Clustered column chart with all other items? I have items on x-Axis and their availability% on y-Axis. Measure called Availability calculates availability of each item in percentage. I'm getting blank value for Item1, which is correct. Item1 was not used during last month. 

Despite that, when I display the Item1 along with others in the Clustered column chart, it shows an incorrect value of 100%.

I will be grateful for any advice. Thanks in advance.

[Pepok_14 · Accepted solution]

Hi @Fowmy / @Anonymous 

thanks for your willingness to help me with this problem. I was able to fix it by rounding numbers to 2 decimal places. I had some small discrepancies on 12th decimal places in some measures, which caused that it was evaluated incorrectly and Power BI visualized wrong data in the Clustered column chart.  

[Anonymous]

Hi @Pepok_14 ,
According to your description, you can try to troubleshoot your problem in the following ways:
1.Adjust the DAX formula for the 'Availability' measure to correctly handle blank or null values. For instance, you might want to use an or function to set the value to 0% when the item has not been used.

Availability = IF(ISBLANK([YourCalculation]), 0, [YourCalculation])

2.Ensure that the data type for your 'Availability' measure is set to Percentage, and the formatting is accurate within the measure settings.

Best regards

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
 

[Fowmy]

@Pepok_14 

Is it possible to show or share a dummy file/chart that represent your scenario?