The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
@Anonymous , create two measures like this and put them bar/clustered visual
count = count(Table[Status])
Delivered = calculate(count(Table[Status]),Table[Status]="Delivered")
@Anonymous , create two measures like this and put them bar/clustered visual
count = count(Table[Status])
Delivered = calculate(count(Table[Status]),Table[Status]="Delivered")