How to group data

[GD61]

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

[Seth_C_Bauer · Accepted 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.

[Seth_C_Bauer]

@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.

[GD61]

Thanks,

The URL of tutorial is:

https://support.powerbi.com/knowledgebase/articles/590610-tutorial-create-calculated-columns-in-powe...

The graph which groups the "inactive" stores is at the very bottom.

It is not explained how they made this grouping

Thanks again

[Seth_C_Bauer · Accepted 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 · Accepted solution]

Great! That works!

Thanks a lot