IF statement return text on bar/line graph

[sakarim]

Hi, I used this solution to return text using an IF statement. It works great for a table/matrix, however, the text value won't appear on a bar or line graph(see picture below). Any thoughts on how to make the text value appear on the bar/line graph?

[sakarim]

Thanks, that works. Is there also a way to change it when you right click and select the "show as a table" option? It still shows the true value in the table.

[Anonymous]

Hi @sakarim ,

Show as table will display the data that's being used to create the visual. This is by design.

Best Regards,
Gao
Community Support Team

[sakarim]

It kind of solves it but the tooltip does not change so it is still showing the true value rather than the new text, is there a way to have the tooltip change too?

[Anonymous · Accepted solution]

Hi @sakarim ,

You can consider using custom tooltips instead of the default ones.

A PBIX file is attached for reference.

Create report tooltip pages in Power BI - Power BI | Microsoft Learn

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Anonymous]

Hi @sakarim ,

PBI Desktop offers custom data labels in the May 2023 release. You can find it here under the data labels:

It allows you to format data labels:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum