Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
I'm studying a tutorial which displays a graph where all the stores with the Status = Off are grouped together.
How can I do that?
Thanks for your help
Solved! Go to Solution.
@GD61 the "grouping" is accomplished in the measure that you create.
They drop "Active StoreName" into the visual and the above code basically says the following:
If the status has a value of "On" than return the StoreName
If the status value does not equal "On" than return the string value of "Inactive"
So if there are 10 stores, and 4 have a status of "On" then each of the 4 stores will show seperately. The other 6 stores are essentially renamed/grouped to "Inactive" - which is how the tutorial "Grouped" the stores.
@GD61 First, can you post the link of the tutorial, and what part are you struggling with?
By default, if you have the dataset loaded into the Desktop, then you should just be able to drop the stores on the work space and then drag the Status field into the same visual, or a seperate visual and make it a slicer, or put it in a filter.
Thanks,
The URL of tutorial is:
The graph which groups the "inactive" stores is at the very bottom.
It is not explained how they made this grouping
Thanks again
@GD61 the "grouping" is accomplished in the measure that you create.
They drop "Active StoreName" into the visual and the above code basically says the following:
If the status has a value of "On" than return the StoreName
If the status value does not equal "On" than return the string value of "Inactive"
So if there are 10 stores, and 4 have a status of "On" then each of the 4 stores will show seperately. The other 6 stores are essentially renamed/grouped to "Inactive" - which is how the tutorial "Grouped" the stores.
Great! That works!
Thanks a lot