How to add Legend - Additional legend that should tell me total values

[MonikaNandhini1]

Hello everyone here.. 

  Plz look into this picture, I chose cluster chart to view Number of closed issues and pending issue. 

But i need one more legend(before closed&pending) that should tell me both( closed + pending ) issues put together seperately 

Kindly help me

- Monika

Below image referance from Pivot chart - Not power Bi 

[dax]

Hi @MonikaNandhini1 , 

You could refer to @MFelix ' s suggestions to see whether it work or not. I suggest you could use Line and stacked column chart to achieve this goal.

Best Regards,
Zoe Zhi

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

[MonikaNandhini1]

Hi..

I tried @MFelix solution, i think its not an exact solution what im looking for. 

I already tried Line and stacked column chart, but i need total values in a bar not as a line. Could you help me to get it 

Thanks 

Monika 

[MFelix]

Hi @MonikaNandhini1 ,

Can you share you sample data? I can make the changes to my solution to give the correct result.

[MonikaNandhini1]

Hi @MFelix  

Thanks for you immediate reply 

Plz find below excel data, copy and paste to work out. 

Serial Number	Status	Cause Area Description	Issue Description
999988	Closed	EVC Quality	Issue A
996888	Closed	EVC Quality	Issue B
960669	Pending	LPT VST	Issue C
998688	Pending	EVC Quality	Issue D
999692	Closed	EVC Quality	Issue E
960920	Closed	LPT VST	Issue F
960893	Closed	EVC Quality	Issue A
961002	Closed	EVC Quality	Issue B
961992	Pending	LPT VST	Issue C
961686	Pending	EVC Quality	Issue D
962479	Closed	EVC Quality	Issue E
962487	Closed	LPT VST	Issue F
963197	Closed	EVC Quality	Issue A
963189	Closed	EVC Quality	Issue B
963391	Pending	EVC Quality	Issue C
963668	Pending	EVC Quality	Issue D
964089	Closed	LPT VST	Issue E
964100	Closed	EVC Quality	Issue F
964103	Closed	EVC Quality	Issue A
964119	Closed	LPT VST	Issue B
964169	Pending	EVC Quality	Issue C
964236	Pending	EVC Quality	Issue D
964427	Closed	LPT VST	Issue E
964089	Closed	LPT VST	Issue F

Thanks 

Monika

[MFelix · Accepted solution]

Hi @MonikaNandhini1 .

As refered the solution is the same as for the previous post.

• Created a new table with the following values:

Category	ID
Total	1
Status	2

• Added the folowing 3 measures:

Total = IF(SELECTEDVALUE('Split'[ID]) = 1 ; COUNT('Table'[Serial Number]); BLANK())

Pending = IF(SELECTEDVALUE(Split[ID]) = 2 ; CALCULATE(COUNT('Table'[Serial Number]);'Table'[Status]="Pending"); BLANK())

Closed = IF(SELECTEDVALUE(Split[ID]) = 2 ; CALCULATE(COUNT('Table'[Serial Number]);'Table'[Status]="Closed"); BLANK())

Now create a Stacked Column chart with the following setup:

• Axis:
  • Cause Area Description
  • Measure
• Values
  • Pending
  • Closed
  • Total

Final result is in attach PBIX file (file in May version of PBI).

You need to also be aware that you need to drill down to the lowest level of the Hierarchy and then sort by the Cause Area Description, also the Hierarchy on the X-Axis need to be kept due to the setup what you can due is to concatenet the labels.

[MonikaNandhini1]

@MFelix  Thank you for your time to take my data to get a solution

Yes, Now Its working, with few correction made. Ex: mentioned ";" instead of "," 

Thank you so much !! 

[MFelix]

Hi @MonikaNandhini1 ,

Check the response I gave in the post below, believe that can help you solve your issue.

https://community.powerbi.com/t5/Desktop/Stacked-column-chart-in-clustern-column-chart/m-p/1117918#M...

If you need help based on your data please tell me.