Forum Discussion

sakarim's avatar
sakarim
Frequent Visitor
3 years ago
Solved

IF statement return text on bar/line graph

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?

 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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

  • sakarim's avatar
    sakarim
    Frequent Visitor
    3 years ago

    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?

  • sakarim's avatar
    sakarim
    Frequent Visitor
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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