Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.