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 everyone!
I am having difficulties in understanding how the Last Value option in a matrix vasiual works.
My matrix contains kpi data across years for different indicators. You see one of them on the screen below.
If I hide historical data I want the visual to display data from 2023, which is the last available. However, it doesn't work as I expected since it mixes the data from different periods.
Unfortunately, I couldn't replicate this behaviour on mock data. Does anyone have any idea why this happens?
@chulpanvl
When you collapse a matrix hierarchy it shows the data summarized by all the years in your case. if you only need to show year 2023 then apply a visual level filter or create a measure that returns the latest year and assign on the visual filter.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi! I don't wanna show 2023 data only. I want to change a summarization method such that the visual shows the latest data (which is as of 2023) when the hierarchy is collapsed and show everything when expanded. Is it possible?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |