Process_Name vs Status Chart in Stacked Column Chart

[tina345]

Hello,

  I am new to Power BI and trying to build one chart.

  My requirement is to show process_name vs Job_Status (failed,passed, Errored-Out etc).

  I am thinking to use 'stacked column chart', but status is coming as count instead of value.I have attached some     screen shots for reference.

Could you please help?Why does power BI gives counts instead of actual value even if I am not summarizing.

 Data for process logs which capture historical data with status

  date1 process1 passed

  date2 process2 failed

  date3 process1 passed

 date4 process1 passed

[Anonymous]

Hi @tina345,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[HarishKM · Accepted solution]

@tina345 Hey ,
You can drag your status to legend section and also at your value (count of status ). and then date and process to axis according to your requirement . Kindly follow below image for your reference .

Attaching file (solution for your reference .)
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 

are nice too.

Thanks & Regards
Harish

[parry2k]

@tina345 on the value section you can only have number values. maybe you can use a matrix visuals

date on columns

process names on rows

and on value use status and change the aggregation to earliest/latest.

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡