Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I need help,
I have table with name Student, I want to show student data in table report and give the user option to re retrive the number of rows depended on the studend mark, such as if the user need to show top 3 , the report resulte contain only to three student
if the user enter 5 the report resulte contain only to five student .... and any value the user enter based on it the # of rows return
Regards,
Hey,
here you will find a pbix file
The file contains sample data for the columns "Name", "Gender", "Nationality", and "Mark".
I addition to the sample data I created a what-if parameter (https://docs.microsoft.com/en-us/power-bi/desktop-what-if)
I created two measures. The 1st measure "rnk Student by Mark" ranks the students by the value of the column "Mark" and a 2nd measure that checks if the selected parameter value (representing the user interaction) is larger or equal to the rank of the student, if this is the case, the measure returns 1. This measure is used as a visual filter.
The measure "rnk Student by Mark"
rnk Student by Mark = RANKX( ALL(Students) ,CALCULATE(MAX('Students'[Mark])) , ,DESC )
The 2nd measure "rnk and Parameter" that I use as toggle in the visual filter section of the table
rnk and Parameter = IF(SELECTEDVALUE('Top N Numbers'[Top N Numbers])>=[rnk Student by Mark], 1,0)
And a screenshot of the report page
Hope this is what you are looking for
Regards
Tom
Hey Tom,
Thanks very much for you reply,
I tried to trace your steps but no any thing change and not fix with me
kin
and I try to import pbiix file but Ican't, please tell me how I can Import it here
Regards
Hey,
to assist you any further, please upload your pbix file to onedrive or dropbox and share the link.
Are there any messages if you try to import my pbix file. Please be aware that I'm always using the latest PBI Desktop version 🙂
Regards
Tom
thanks Tom,
I share pbix file here, the report inside page 1 ,kindly trace what is the error with me and thanks advanve
Regards
Mohammed
Hi,
I need help,
I have table with name Student, I want to show student data in table report and give the user option to re retrive the number of rows depended on the studend mark, such as if the user need to show top 3 , the report resulte contain only to three student
if the user enter 5 the report resulte contain only to five student .... and any value the user enter based on it the # of rows return
Regards,
Hey,
as far as I can see this is a duplicate question.
Look here for my answer, you may consider to delete this question
Regards
Tom
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |