Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to display Text values on Bar chart?

Hi Power BI Team,    I've below data.  Here the our requirement is to compare PlanMonth Vs Actual Month, 1. If PlanMonth & ActualMonth are same then show Plan as 1, Act as 1.  2. if PlanMo...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    Hi, Anonymous 

     

    As far as I know, this is impossible to achieve, the value has its own value attribute.
    The bar graph itself cannot display text. The reason why I suggest you change your judgment condition to -1 is to keep the attribute of the value. The reason why it is -1 instead of 1 is because the custom formatting acts on positive, negative and zero values. Use -1 to distinguish it from the other two cases (1, 0).


    According to your expectations, 1 and 1* are on the same horizontal line, which means that the value of 1* is 1. This cannot distinguish 1 from another 1. This is the purpose of -1. Once -1 is used, there are positive and negative axes, which cannot be avoided. Although the final result has a positive and negative axis, it better shows the actMonth.

     

    Glad to see different solutions.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • mwegener's avatar
    mwegener
    5 years ago

    Hi Anonymous  ,

     

    are you familiar with the External Tool Tabular Editor?

    You need to download and install it first.
    https://github.com/TabularEditor/TabularEditor/releases/tag/2.16.1


    After the installation, you can start it from the menu bar.


    Here you can create a Calculation Group (Table).


    Here you create a Calculation Item.


    Define the "Expression"


    Define the "Format String Expression" and save the change


    This solution is not yet optimal but a kind of proof of concept.

     

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
5 years ago

Hi, Anonymous 

 

Do I have to use 1* text? Can I use -1 instead? so the answer is much simpler.
The use of text values in bar charts is not allowed. But if you format -1 as a text 1*, it can be done.

So change the result of  the condition:

if PlanMonth < ActualMonth then Plan as 1, Act as -1
Then use custom conditional formatting in the model like below:

Finally, invert the x-axis to beautify the bar chart

Hope this helps.

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

I did follow your method but I get * for every value. Please see the below image. 

The below your screen Act column is exactly our requirement. but I am not getting it. Need more help on this. Thanks!