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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
93 | |
86 | |
80 | |
69 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |