Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
GD61
Helper III
Helper III

How to group data

Hello,

I'm studying a tutorial which displays a graph where all the stores with the Status = Off  are grouped together.

Off Status

How can I do that?

Thanks for your help

2 ACCEPTED SOLUTIONS

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


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

Great! That works!

Thanks a lot

View solution in original post

4 REPLIES 4
Seth_C_Bauer
Community Champion
Community Champion

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


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

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

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


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Great! That works!

Thanks a lot

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!