Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to 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
Proud to be a Super User!
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
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
89 | |
80 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
115 | |
109 | |
74 | |
69 |