Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
87 | |
84 | |
68 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |