Forum Discussion
Helper IRanking names with multiple years
Hello community,
I have a new challenge to complete!
I would like to automatically select different names out of a dataset per page. I thought about this a lot and came up with the following solution:
I want to rank the names bij alphabetical order and select per page, wich ranks will be visualized.
Example:
Name: Rank:
A 1
B 2
C 3
D 4
Select on page 1: rank<3, Select on page 2: 3<rank<5 etc.
This is working fine with one year of data. Now that is unfortunately not the case in my challenge. I have multiple years of data per name and when I want to rank that, PowerBI does not really know what it has to do (I think I give it the wrong instructions)
Can anyone give me a headstart on how to do this? The key elements of the code has to have: Name, Year and Rank
Or if anyone has a more efficient solution, that would also be great!
Kind regards,
Jennifer
5 Replies
Hi DMSJennifer,
You can create a measure expression as a filter to filter visual records based on a parameter/filter, but the current report pages are not availed to interact with DAX expressions.
For this scenario, you may need to add a disconnected table as the source of the slicer on each page and use it to interact with measure expressions and set the slicer to invisible.
Regards,
Xiaoxin Sheng
- Ashish_Mathur
Super User
Hi,
Share some data and show the expected result.
- DMSJennifer
Hello Ashish,
The dataset looks like this
And what I want it to do, is the following:
Is this information enough?
Kind regards,
Jennifer
- Ashish_Mathur
I do not understand what you want.
