Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a case when X-axis Type is Continuous it will show month Jan-Jul; However; I want to all month to be displayed.
If I select select Categorical Type it will show weekly.
I need to show all months in parallel with displaying weekly in the graph.
Data:
Regards,
Use a date dimension table and create a hierarchy, but weeks don't work well within months because some weeks overlap two months.
- https://exceleratorbi.com.au/build-reusable-calendar-table-power-query/
@BP2022
Ive often solved the this behavior by simply re sizing the visual. Ive seen it at times making the visual larger will make all the months display as desired. When there is limited space PBI seems to 'skip display months' . This often rsults in me needing to change the BI Narrative as I didnt have room to make it bigger. I solved that by moving the visual to its own page with a drill thru / bookmark to navigate to it.
Alternative, I have also used the Categorical Type but had to alter the visual. To get the month name to show I used a date dimension for the Month Name only (no hierarchy). This should achieve you desired layout with no 'skip months'. Then to get the weekly details I created a duplicate chart but used week instead of month. I then layer these visuals ontop of each other with a button bookmark to allow the users to toggle between monthly or weekly view.
Hope it helps, mark it as a solution if it does.
Thank you for your respone.
The first solution you share it will not work becasue I have to minmize the graph. The second solution, we have user using the graph by filting and exporting data this solution will not help.
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.