Forum Discussion
TOPN with parameters & slicers
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.
Super UserPlease 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/1447523
Thank 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.
Thank you very much again!
It must be due to my bad English, but this is not what i'm looking for. Your table shows the max. value of rain for 1 day in jan.
What i'm looking for is:
How is a specific period (could be a single day, week, month, quarter or year) be compared to the top 10 of the same period in previous years.
Example:
The amount of rain on 15-01-23, how does it compare to the amount of rain on the same day (15-01) in the previous years. And show it in a bar chart with the top 10 results (years) desc.
Or,
The total amount of rain for december 2023, how does it compare to the total amount of rain in the same month (december) in the previous years. And show it in a bar chart with the top 10 results (years) desc.
Or,
The average max. temp for the month of june 2023, how does it compare to the the average max. temp. in the same month (june) in the previous years. And show it in a bar chart with the top 10 results (years) desc.
The period (date/week/month/quarter...) must be dynamic, so handled by slicer (not by filter).
Below a sample of how it should look like, beware this is NOT based on my data. Just to give you an idea.Again many thanks for trying to help me out with this!!
Best regards, Rud.
