Clustered bar chart from 2 columns that share values

[nickninenine]

Hello all,

This is probably rather simple, but I couldn't find the correct answer after much research.

I have two dates, one is the date an order is made, and another is the date the order is started. I have made a column for each that transforms these dates into day of week names (ie Monday, Tuesday...)

In excel, I could load these columns up into a cluster bar chart that looks like this:

When I try to do the same in Power BI, the columns always have the same number.

I have resorted to just making two separate charts for now, but it would be great to combine these into one.

Thank you!

[pratyashasamal · Accepted solution]

Hi @nickninenine ,
This issue can we resolved using inactive relationship and an measure .
You would need to create inactive realtionship for the order start date and use "USERELATIONSHIP" function to create a relationship .
You can refer to this link to follow steps by step :-
https://hatfullofdata.blog/power-bi-using-inactive-relationships-in-a-measure/
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C