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,
I have a flat table which has several thousand organisations each with prevalences for about ten different conditions. All the organisations also have a rank associated with them based on where they are in the country (this rank is in another table joined on org code)
What I would like to do is for the end user to be able to pick an organisation in a slicer to show all that organisations prevalences and for the report to automatically present the prevalences of the organisation closest to it in the national rank.
Does anyone have any ideas?
Thanks in advance
Solved! Go to Solution.
Hi @Parosel
You can create a disconnected table which a duplicate of the ranking table adding to it the organization name
Slicer Table =
ADDCOLUMNS (
'Ranking Table',
"Organization ", CALCULATE ( VALUES ( 'Organizations Table'[Organization] ) )
)
Then create your filter measure
Filter Measre =
SELECTEDVALUE ( 'Ranking Table'[Ranking] )
- SELECTEDVALUE ( 'Slicer Table'[Ranking] )
The place this measure in filter pane and Filter Measre =
Select "greater than" and insert the value "-5"
then
select "And"
then
Select "less than" and insert the value "5"
you can change the value to increase or decrease the range size
Hi @Parosel
You can create a disconnected table which a duplicate of the ranking table adding to it the organization name
Slicer Table =
ADDCOLUMNS (
'Ranking Table',
"Organization ", CALCULATE ( VALUES ( 'Organizations Table'[Organization] ) )
)
Then create your filter measure
Filter Measre =
SELECTEDVALUE ( 'Ranking Table'[Ranking] )
- SELECTEDVALUE ( 'Slicer Table'[Ranking] )
The place this measure in filter pane and Filter Measre =
Select "greater than" and insert the value "-5"
then
select "And"
then
Select "less than" and insert the value "5"
you can change the value to increase or decrease the range size
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 |
---|---|
41 | |
26 | |
20 | |
13 | |
8 |
User | Count |
---|---|
76 | |
48 | |
46 | |
20 | |
16 |