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.
Hi-
I have a table that has zip codes for rows and segmentation counts as columns. I am agreggating on our trade areas, which is a set of zip codes. I want to be able to have a visualization that shows me the top 5/10 etc segments present in this trade area. Any idea how this could be accomplished?
Thanks!
Hi @JCik,
The easist way is to use the TOPN filter option on the visual level or report level, if you want you can also use the RANKX function. However both of this options need to have a column as referenced to make the TOPN can you give based on the sample data and expected result and to what column you are comparing?
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks! But I don't think that will work for this
In the example below I would only want to have the top 3 columns pulled into a visual or at least have a row below the totals with the ranking of that column so Money & Brains would be #1, Yound Digerati #2 etc
Hi @JCik,
What's "Money & Brains" in your first post? I'm afraid we can't add columns dynamically. I would suggest you unpivot these columns or create a new table.
Best Regards,
Dale
Money and Brains is a segment name (PRIZM segmentation). Essentially my table consists of every zipcode in America as rows and then the 68 different segments as columns with # of HHs that fall into each segment as values. We have defined trade areas (custom set of zip codes) that i wanted to show the dominant 5 segments in those areas but suspected that it might not be able to be done.
Thanks!
User | Count |
---|---|
127 | |
72 | |
70 | |
58 | |
53 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |