Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
i have created the foolowing visual which shows the topN sales person based on the slicer value.
But as soon as i put region in legends, it no longer shows me top 4 sales person overall but top 4 for all the regions.
I would like to use region in legends but need only top 4 sales person irrespective of the region and not for all regions. Here is the what i am getting
Please help with a solution
Solved! Go to Solution.
1-Create a meaasure:
SalesTotal = SUM(PersonRegionTable[sales])
2-Create a rank measure:
RankMEasure =
RANKX ( ALLSELECTED ( PersonRegionTable ), [SalesTotal] )
3-Create a measure for your slicer value which is selected:
TOPNVALUE = SELECTEDVALUE(TOPNTABLE[VALUES])
4-Create a measure as filter on the visual:
FILTERMeasure =
IF ( [RankMEasure] <= [TOPNVALUE], 1, BLANK () )
Then put the [FilterMeasure] on your Visual as Filter on this visual on FilterPane and set it equals to 1.
If this helps you, accept it as a solution.
Regards,
Loran
Hi @MeghnaZutshi ,
If you use the Filter Pane TOPN option, it works as you expect.
Btw, if you need to use your approach, please share a sample .pbix then we can fix your measure.
Regards,
Loran
Hi @MohammadLoran25 ,
Thanks for the solution. TOPN in filter pane works fine but i need TOPN to be based on the parameter chosen by the user in the slicer. I have attached my file, can you please help me with the solution .
@MohammadLoran25
Not able to upload file here. here are my measures:
It should show region as well which is there in the legends
1-Create a meaasure:
SalesTotal = SUM(PersonRegionTable[sales])
2-Create a rank measure:
RankMEasure =
RANKX ( ALLSELECTED ( PersonRegionTable ), [SalesTotal] )
3-Create a measure for your slicer value which is selected:
TOPNVALUE = SELECTEDVALUE(TOPNTABLE[VALUES])
4-Create a measure as filter on the visual:
FILTERMeasure =
IF ( [RankMEasure] <= [TOPNVALUE], 1, BLANK () )
Then put the [FilterMeasure] on your Visual as Filter on this visual on FilterPane and set it equals to 1.
If this helps you, accept it as a solution.
Regards,
Loran
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |