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.
Hi Everyone,
Hope all's well!
I am trying to create a comparison of 2 stores one beside other with variance and % difference.
To begin with i am trying to give the capability of filtering 2 different stores one beside other and i am stuck.
i have used these calculations -
Hey @Krishna2285 ,
can you please provide a screenshot/scribble of how you want the comparison to look like.
Regards,
Tom
Hi Tom,
Here is look like from excel -
And why can't you just select two stores from a single slicer?
I have to admit that I can not see how the comparison of two stores is happening in the Excel table.
In excel it lookinup from a another sheet and creating a row for each category.
later its just a-b to get the variance.
Where as if i filter 2 stores and get the results how can add a measure to a store summarised value.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
89 | |
80 | |
60 | |
60 | |
58 |
User | Count |
---|---|
155 | |
119 | |
104 | |
78 | |
71 |