Conditional formatting of x-axis along with Legend formatting

[PC2790]

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?

[negi007]

@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

[PC2790]

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