Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Numbers and text in X-axis line/area chart

Hi team, I have an area chart where  X-axis is year/month field, y-axis is a value. Date Value 2023-08-01 null 2023-09-01 48%   Is there a way, if I have an empty (null) value fo...
Need Help
Show and Tell
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi Anonymous 
    You can use customized labels for these results :

    Create a measure like :

    label = IF([value_]>0,FORMAT([value_],"0%"),"no campaigns" )
    and put it on the graph:

    PBIX is attached

    More information about customized labels is here:

    https://www.youtube.com/watch?v=MHaIDMu73sw

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

     

  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi Anonymous 
    Yes of course it is working from service...
    The image after publishing :

     

    Try to publish the report again, and Refresh the web page with F5 after publishing

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

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

Hi Anonymous 
You can use customized labels for these results :

Create a measure like :

label = IF([value_]>0,FORMAT([value_],"0%"),"no campaigns" )
and put it on the graph:

PBIX is attached

More information about customized labels is here:

https://www.youtube.com/watch?v=MHaIDMu73sw

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Ritaf1983 ,

    Thank you very much for the solution- it works!

    Quick question -I updated my report in PBI desktop, but in PBI Service (after upload), the text "no campaings" doesn't show.  Is this work with you in the service or have you ever tested this custom label  in pbi service?

    Thank you.

    • Ritaf1983's avatar
      Ritaf1983
      Icon for Super User rankSuper User
      2 years ago

      Hi Anonymous 
      Yes of course it is working from service...
      The image after publishing :

       

      Try to publish the report again, and Refresh the web page with F5 after publishing

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