Hide data points on line chart

[0tk]

I have a line chart as below,

Is there a way to hide data points where it's zero. I basically don't want to connect where it's  zero. In this exampl,e it should show lines till May and a single dot for the last value "YTD".

[SamInogic · Accepted solution]

Hi @0tk ,

In Power BI Formatting properties, there is no direct option to disable the data label for 0 values as they provide option to either enable or disable the data labels.

But as a workaround you can use below approach,

If your graph is with background white colour as shown below screenshot.

We will create a custom column in the table with below DAX expression,

DataLabelCOlor = IF('Sample Data'[Value] =0, "White","")

Then navigate to Data Label Setting options in Format Your Visual section and find the Values area where we can give Conditional Formatting to the Data Label text.

Please refer to the below screenshot for the same,

Click on Conditional Formatting icon and it will open a Color – Series dialog where you can select the Format Style as “Field Value” and select the field “DataLabelCOlor” from table,

Then click Ok, now the Labels having value as 0 will be hidden and other data will be displayed.

Thanks!

Inogic Professional Services Division

Power Platform and Microsoft Dynamics 365 CRM Development – All under one roof!

Drop an email at crm@inogic.com

Services:  http://www.inogic.com/services/

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/