Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi i am used to dynamic filter in Excel, but if i want to create a matrix table with the following values( Price per unit) based on the filter:
TOP 3 Maximum price per unit
TOP 3 Minimum price per unit
Is there an easy way to do so?
Solved! Go to Solution.
@bilingual , need to create 2 different matrix visual for top 3 and bottom 3 as only one top N filter can be applied to a visual at a time.
@bilingual , need to create 2 different matrix visual for top 3 and bottom 3 as only one top N filter can be applied to a visual at a time.
Thanks a lot, couldn find it, if i want to create a filter, with TOP and BOTTOM 3 bottom, can you help me? - The values are based on a measure.
@bilingual Go to View Tab, there is an option for filters. Then in the filter pane click on the field which has to sorted for top 3 or bottom 3. Expand it and change Filter type to TOP N, select either top or Bottom and the number, also the value on which top/bottom N is being ranked.