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
mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
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.

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Mwegner,

Thanks for the kind reply so far!

Actually I achieved Act & Plan bars as per your instructions. 

Only two things to be resolved. 

1. I'm getting Y-Axis scale has 1 and 1 instead 0,1,2...... As shown below.

2. I've a Italy data as below. and if you see 02 Plan records in June Month.   

 

According the above screenshot expecting the below as output:

But at present I'm getting as below:

 

Looks like some where we need use Count Aggregation. I did see you used Max function. 

I highly appreciated so far and I'm really looking forward to fix this. Thanks

 

 

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    Hi Anonymous ,

     

    I have adjusted the Format String Expression for the Y-Axis.

    VAR maxPlanMonth =
    MAX ( 'Audit Fulfillment INT'[PlanMonth] )
VAR maxActMonth =
    MAX ( 'Audit Fulfillment INT'[ActualMonth] )
RETURN
    SWITCH (
        TRUE,
        maxActMonth = BLANK (), "0",
        maxPlanMonth <> maxActMonth, "0*",
        "0"
    )

     

    How should the counting be done if the rows would have to be formatted differently?