March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
165 | |
116 | |
63 | |
57 | |
50 |