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.
Hi All,
how can we achieve below requirement?
there is a metric slicer, if i choose 'AVERAGE' the it should sort Average measure by ASC order, elseif i choose 'DISMISSALS' then it should sort Dismissals measure by DESC order.
i am not able to achieve the sorting requirement
Data:
Batsman Average Dismissals
Virat Kohli | 100 | 5 |
Kedar Jadhav | 62 | 1 |
Rohit Sharma | 51.9 | 10 |
Shikhar Dhawan | 34.4 | 12 |
MS Dhoni | 24.77 | 9 |
Chart:
Thanks,
Raj
Solved! Go to Solution.
Hi @RajeshLM ,
First create a slicer table as below:
Then create 2 measures as below:
Measure =
SWITCH(SELECTEDVALUE('Table (2)'[Slicer]),"Average",MAX('Table'[Average ]),"Dismissals",MAX('Table'[Dismissals]),BLANK())
Measure 2 =
SWITCH(SELECTEDVALUE('Table (2)'[Slicer]),"Average" ,
RANKX(ALLSELECTED('Table'),'Table'[Measure],,ASC,Dense),
"Dismissals",
RANKX(ALLSELECTED('Table'),'Table'[Measure],,DESC,Dense))
And you will see:(make measure 2 as a tooltip field)
For the related .pbix file,pls see attached.
@RajeshLM , Are able to sort on the measure(Using the three dots) on the visual. then it should sort or the whatever has been selected.
No Amit, using those 3 dots i cannot sort the way i need.
if i choose 'AVERAGE' the it should sort common measure(Measure) by ASC order, elseif i choose 'DISMISSALS' then it should sort common measure(Measure) by DESC order
Hi @RajeshLM ,
First create a slicer table as below:
Then create 2 measures as below:
Measure =
SWITCH(SELECTEDVALUE('Table (2)'[Slicer]),"Average",MAX('Table'[Average ]),"Dismissals",MAX('Table'[Dismissals]),BLANK())
Measure 2 =
SWITCH(SELECTEDVALUE('Table (2)'[Slicer]),"Average" ,
RANKX(ALLSELECTED('Table'),'Table'[Measure],,ASC,Dense),
"Dismissals",
RANKX(ALLSELECTED('Table'),'Table'[Measure],,DESC,Dense))
And you will see:(make measure 2 as a tooltip field)
For the related .pbix file,pls see attached.
@RajeshLM - I believe that you would need a disconnected table and a single measure that switches between the average and dismissals based upon the slicer selection. In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...
Thanks Greg.
Infact i have created a disconnected table and a single measure that switches between the average and dismissals based upon the slicer selection. but i am stuck with the sorting - Average should sort by Asc and Dismissals should sort by Desc.
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 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |