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.
I have a TOPN Sliver that uses the following values.
Pages where I use the TOPN show all results as a defualt. Is there a way to set a default such as Top 6 and still use a TopN Slicer? That way pages can still be printed after publishing and not have scroll bars.
Ok I got to work like the video. The Slicer creates choices from 0 to 20
@bdehning , Assuming this table is independent Table and you using
Num= maxx(allselected(Table), Table[TOPN Number]) in the topN function
You can have measure where do not use it
example
AverageX(keepfilters(topn(6, allselected('Fact Jobs'[Column]) ,[Measure], desc)),[Measure])
measure that use slicer
AverageX(keepfilters(topn([Num], allselected('Fact Jobs'[Column]) ,[Measure], desc)),[Measure])
Learn Power BI: Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ
I am using an Independent Table of TopNTable which has TopN column and TopNValues Column. So I guess I am not using Num= maxx(allselected(Table), Table[TOPN Number]) in the topN function?
I will need to watch the Dynmaic TOPN video.
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 |
---|---|
102 | |
101 | |
87 | |
73 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |