The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I want to see a value for all the weeks in a year. But when I add months also as a filtering option, since week can be part of two months, it shows two separate bars in the visual. Therefore, I just want to see months being displayed below my weeks on x axis but just to give an idea of when a month starts and ends instead of using months for filtering.
Solved! Go to Solution.
Hi @afaro
You can use a hierarchical X-axis to see the "limits" of every month:
To have this form, with the month on the bottom you have to switch off the "concatenate labels" option:
pbix with example is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @afaro ,
There are multiple ways to produce your required output, and one of them is using ConcatenateX to show in one week line, the concatenated month information as follows so that if the week is straddled by two months (i.e., if the current month ends and another month begins in the same week), it will be shown as two mmm-yyyy for easy identification of this fact.
I attach a pbix file as an example.
Hi @afaro ,
There are multiple ways to produce your required output, and one of them is using ConcatenateX to show in one week line, the concatenated month information as follows so that if the week is straddled by two months (i.e., if the current month ends and another month begins in the same week), it will be shown as two mmm-yyyy for easy identification of this fact.
I attach a pbix file as an example.
Hi @afaro
You can use a hierarchical X-axis to see the "limits" of every month:
To have this form, with the month on the bottom you have to switch off the "concatenate labels" option:
pbix with example is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
102 | |
82 | |
62 | |
56 |
User | Count |
---|---|
254 | |
119 | |
115 | |
99 | |
71 |