Display the two count measures and percentage measure on same stacked column chart

[ce138867]

Hi All,

I have multiple measures:

New Count

Closed Count

Run Rate New/Closed (%)

Organization Name

I'm trying to display this on either a stacked cluster chart or a line and stacked cluster chart but I'm having a hard time getting this to display the way I need it to.  

I've chosen the line and clustered column chart with the following

X Axis = Organization Name

Column Y = Run Rate New Closed(%)

Line Y = New Count, Closed Count

Tooltips = New Count, Closed Count

Tried applying Categories Rules on the Column but it's not working.

Two things I'd like to do.

1. Display three values display in a tooltip(%, New and Closed). What am I doing wrong that's not allowing me to see this? Do I have to create a custom tooltip for Organization Name?

2. Display the column in green if run rate >=100%, otherwise display red.

Appreciate the help in advance.

[v-yangliu-msft]

Hi  @ce138867 ,

As far as I know, line and stacked cluster charts can only place calculated columns on the X-axis, and the measure is essentially an expression that groups calculations based on the X-axis and Legend data.

You could consider using the calculated column to create [Organization Name] to be placed in the X-axis.

Organization Name Column =
SWITCH(
    TRUE(),
    'Table'[Group]=1,"A",
    'Table'[Group]=2,"B",
    'Table'[Group]=3,"C")

For Color - Categories, you can set it as below:

Result：

Best Regards,

Liu Yang

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

[ce138867 · Accepted solution]

Thanks @v-yangliu-msft for the help. I was able to get this done using the original setup I had. I'm not sure why it worked when I deleted the entire visual and rebuilt it?

Since I can't attach pictures or files. I'll try my best to explain the setup.

Table 1:

Measure: New Count

Measure: Closed Count

Measure:Run Rate New/Closed (%)

Table 2:

Column: Organization Name

Visual Settings:

Line and cluster column chart

X axis: Org Name

Column Y axis: Run Rate New/Closed(%)

Line y axis: Closed Count, New Count

Tooltips: Closed Count, New Count

Columns Color Formatting:

Rule 1: If value of Run Rate New/Closed(%) = 100% then green

Rule 2: If value of Run Rate New/Closed(%) >=0% and <=99%, then red

Thanks!