Forum Discussion
TOPN with parameters & slicers
Hello all,
I have a table with weather details.
Every day, for 50 years, details like max. temp & mm. rain are updated.
Below you see a screenshot of an overview page, with on top the parameter (12 items) and on the right slicers for year / decade / month / date etc.
I would like only the bars for the top10 results to be shown. For example the top 10 days/weeks/months/years based on total mm. rain for the past 50 years ... or the top 10 days/weeks/months/years based on the average max. temp in the past 50 years ... and so on.
Besides that would it be nice of the bar of this year would have an slighty different color.
Would appereciate your help / tips very much.
Thkx in advance, Rud.
see attached for an approximation. Your "TOP 10" request is very complex, and may not be needed.
I am not aware of an automatic indentation option - you will need to traverse the matrix hierarchy yourself after you selected the filter granularity.
6 Replies
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Thank you very much for your reply !
I hope this will make things clear.
Below you'll find a link to the source data.
This is weather data since 1951.
Data2 sourceI would like to visualize the following in a bar chart:
Top10 for all the items for all the periods (by slicer).
For example:
TOP10 years (desc) for the month jan. with the most monthly rain in mm.
TOP10 years (desc) for the years mith the most anual rain in mm.
TOP10 years (desc) for the days 01-march with the most daily rain on that day.
And so on, depending on slicer settings (see attachment).
Same for the average max. temp / min. temp.
If the current year is in the TOP10, the bar of the current year should be in a different colour.
Hope this gives a better understanding.
Thankx in advance and all the best for 2024 for you (all).
Best regards, Rud.- lbendlin
Please confirm that you need bar charts for all of these - that would mean you couldn't use a proper calendar table.
Alternatively you could use table visuals.
