Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I have a matrix visual that is basically showing the following:
Fields are:
Status - basically parent category to Task (i.e. Advance, Develop, etc.)
Task - the name of the task what was completed
Then I have a column called "# of Completed Tasks"
I am being asked to provide the top 5 tasks and the bottom 5 tasks. It's already filtered for top 5, but I didn't know how to do both top 5 and bottom 5 in the same matrix visual. Has anyone done this before?
So basically what I'm looking for under each status category is something like this...
Anyone have any easy ideas?
Solved! Go to Solution.
Hi
Modify dax as per you need.
Top Bottom =
VAR __Products =
FILTER (
ADDCOLUMNS (
SUMMARIZE (
ALLSELECTED ( Products[Product] ),
Products[Product]
),
"@Sale", [Sales]
),
NOT ISBLANK ( [@Sale] )
)
RETURN
CALCULATE (
[Sales],
KEEPFILTERS (
UNION (
TOPN ( 5, __Products, [@Sale], ASC ),
TOPN ( 5, __Products, [@Sale] )
)
)
)
Or refer below videos
https://www.youtube.com/watch?v=mdj2ilk4rGc
I hope I answered your question!
Hi
Modify dax as per you need.
Top Bottom =
VAR __Products =
FILTER (
ADDCOLUMNS (
SUMMARIZE (
ALLSELECTED ( Products[Product] ),
Products[Product]
),
"@Sale", [Sales]
),
NOT ISBLANK ( [@Sale] )
)
RETURN
CALCULATE (
[Sales],
KEEPFILTERS (
UNION (
TOPN ( 5, __Products, [@Sale], ASC ),
TOPN ( 5, __Products, [@Sale] )
)
)
)
Or refer below videos
https://www.youtube.com/watch?v=mdj2ilk4rGc
I hope I answered your question!
Create measure like this:
Thank you so much!! Both options are very helpful. I really appreciate you guys!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |