Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Greetings community,
I have come across a requirement which seemed to be easy in the beginning but it is quite strange that I am not able to get the desired result.
Here it goes:
I have data similar to this:
ID | Status | Stage | Priority |
1 | In progress | S1 | 1 |
2 | Cancelled | S3 | 2 |
3 | Pending | S1 | 3 |
4 | Completed | S2 | 1 |
5 | Completed | S2 | 2 |
6 | In progress | 2 | |
7 | Pending | S1 | 1 |
8 | Cancelled | S3 | 3 |
9 | In progress | S2 | 1 |
10 | Pending | S1 | 3 |
I created a bar chart as this:
For the colors of the bars, I have done conditional formatting using DAX as below:
Status color =
SWITCH (
TRUE (),
SELECTEDVALUE ( 'Table1'[Status] ) = "In progress", "Red",
SELECTEDVALUE ( 'Table1'[Status] ) = "Completed", "Yellow",
SELECTEDVALUE ( 'Table1'[Status] ) = "Pending", "Blue",
SELECTEDVALUE ( 'Table1'[Status] ) = "Cancelled", "Green"
)
Now the requirement is that I have to put legends in form of Priority so that bar shows hoe many of them have what priority.
Expected outcome:
as per:
How is that achievable?
@PC2790 unfortunatley this is not possible as you can't have two different conditions for the chart. However, you can try to use some trick to have this one. You can create two charts and super impose one chart over other like below
have also attached the pbix file for reference
Proud to be a Super User!
Thankyou @negi007
That's quite a smart solution but it will not oslve my purpose as no where it shows the Priority value anywhere.
if anyone has any other solution or a better way of show casing this, please help me with it.
thankyou
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |