Line chart percentage format issue due to blank values

[RLBGA]

Hello everyone,

I face an issue on formatting my line chart because of blank rows. As you can see on the following screen, my Y axis is not formated in percentage because the first value of "Actual LY" blue line is blank. However, when the first value that is evaluated is not blank, my axis is well formated.

I also found that if "Actual CY" is displayed on the first position in the legend, my axis is properly formated (certainly because the yellow line is "executed" first).

Does anybody have a clue on how to solve that ?

Kind regards,

[v-luwang-msft]

Hi @RLBGA ,

Is this what you are referring to? It is normal to look at this situation.

Best Regards

Lucien

[RLBGA]

Hi @v-luwang-msft ,

What I mean is if the first item displayed in the legend has a blank value for the first period (like in my example), the Y axis will not be formated properly (you can make the test by reversing the sorting of your legend).

Thanks,

[RLBGA]

Hello @v-luwang-msft , thanks for your answer !

Can you just switch the sorting of the legend by putting value in first position and then value 2 ? It should generate my problem.

Thanks,

[v-luwang-msft]

Hi @RLBGA ，

In my tests, everything works fine, even if the first one is empty, the Y-axis is the percentage shown.

And you could refer my pbix file.

If question still not solved ,could you pls share your pbix file .Remember to remove confidential data.

Best Regards

Lucien