Forum Discussion
How to do it in PBI Desktop?
Cool dude.
It is very simple. do the following steps
1
2
3
Let me know if any help needed
The other thing I would suggest you do is create a Calculated Column Date in your table
Date = 'Table'[Month] & "/1/" & 'Table'[Year]
Then change the Data Type in the Modeling Tab to Date
Now because this Column is of Data Type - Date you'll get a nicer Date Hierarchy
So go back to chart and drag the Date Column to the Axis field - get rid of Quarter and Day
And the use the drill down button in the top left corner of the chart to go to the lowest level
Hope this helps! :smileyhappy:
Community ChampionThe other thing I would suggest you do is create a Calculated Column Date in your table
Date = 'Table'[Month] & "/1/" & 'Table'[Year]
Then change the Data Type in the Modeling Tab to Date
Now because this Column is of Data Type - Date you'll get a nicer Date Hierarchy
So go back to chart and drag the Date Column to the Axis field - get rid of Quarter and Day
And the use the drill down button in the top left corner of the chart to go to the lowest level
Hope this helps! :smileyhappy:
Thank you very much, Your solution is very helpful:smileyhappy: