Forum Discussion
Grouped Bar Chart with Multiple Values
I'm trying to create a grouped bar chart with two differnt Values but I only want to filter one value.
My data set is structure like this:
| Region | Status |
| NA | Delivered |
| NA | In Process |
| NA | Delivered |
| CAN | Delivered |
| APAC | In Process |
| CAN | In Process |
| APAC | Delivered |
| APAC | Delivered |
| APAC | Delivered |
Which I'm wanting a bar chart that shows the total per region grouped with the total status of Delivered. I can do this in Excel just not sure how to do this in PowerBI.
Anonymous , create two measures like this and put them bar/clustered visual
count = count(Table[Status])
Delivered = calculate(count(Table[Status]),Table[Status]="Delivered")
1 Reply
Anonymous , create two measures like this and put them bar/clustered visual
count = count(Table[Status])
Delivered = calculate(count(Table[Status]),Table[Status]="Delivered")