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 Power Bi User,
I am trying to apply a filter conditions at visual level filter with top 5 records of my customer and top 5 countries..
i am not able to place two dimension filters with top N results. can you please suggest is there any way to get the filtering?
Please suggest.
Above is the error i am facing.
Regards,
Rajendra
Solved! Go to Solution.
If you’d like to filter the TOP 5 of customer and TOP 5 countries by the same argument (i.e. [Sales]), you can use the TOP N filter once, and you’ve got the 2 dimensions results.
If you’d like to filter TOP 5 of customer by sales, and TOP 5 countries by volume, it’s not accessible to apply them in same visual coz the logic is mixed up. You can use the measure below, and filter the measure without blank:
Measure 3 = IF(RANKX(ALL(Table1),CALCULATE(SUM(Table1[Sales])))>5||RANKX(ALL(Table1),CALCULATE(SUM(Table1[Volume])))>5,BLANK(),1)
Best regards,
Dina Ye
If you’d like to filter the TOP 5 of customer and TOP 5 countries by the same argument (i.e. [Sales]), you can use the TOP N filter once, and you’ve got the 2 dimensions results.
If you’d like to filter TOP 5 of customer by sales, and TOP 5 countries by volume, it’s not accessible to apply them in same visual coz the logic is mixed up. You can use the measure below, and filter the measure without blank:
Measure 3 = IF(RANKX(ALL(Table1),CALCULATE(SUM(Table1[Sales])))>5||RANKX(ALL(Table1),CALCULATE(SUM(Table1[Volume])))>5,BLANK(),1)
Best regards,
Dina Ye
Hi @rajendraongole1 ,
If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!
Best regards,
Dina Ye
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |