Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello, I would like you to help me to elaborate the following:
I want a column in this table chart that lists the results (rows that are obtained after applying month filters). Example: That if I select the month of September, the 6 projects appear listed from 1 to 6 (in the index column), if I change the month, that the rows from 1 to n appear.
Solved! Go to Solution.
hI @Syndicate_Admin ,
You need to use the Rankx function of DAX. click here to see a detailed example.
Similar question refer:
https://community.powerbi.com/t5/Desktop/Number-of-row-adjusted-to-filters/m-p/1684219
And if quesiton still not solved ,pls provide sample data and expect output result.
Best Regards,
Lucien
hI @Syndicate_Admin ,
You need to use the Rankx function of DAX. click here to see a detailed example.
Similar question refer:
https://community.powerbi.com/t5/Desktop/Number-of-row-adjusted-to-filters/m-p/1684219
And if quesiton still not solved ,pls provide sample data and expect output result.
Best Regards,
Lucien
You may want to specify what the order should be inside the month. Is it alphabetically? by start date? Is the order impactable by a filter choice or can it be a calculated column?
User | Count |
---|---|
83 | |
77 | |
72 | |
70 | |
55 |
User | Count |
---|---|
107 | |
98 | |
86 | |
79 | |
67 |