Forum Discussion

AlKS's avatar
AlKS
Regular Visitor
9 years ago

Full date into month/year

Hi,  Im having difficulties trying to plot the date in month groups.  I have a date column as dd/mm/yyyy.  I want to show mm/yy on visuals but am having issues making this happen.    If I select the ...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi AlKS,

 

Assume the sample data below:

 

 

You can use a column chart visual, then drag date column to Axis, it will generate date hierarchy automatically. You can delete the Quarter and Day, keep Year and Month. Put Amount in Values. Then expand all the level via this

 

 

If the above result doesn't meet your requirement, please clarify it.

 

Reference:

Drill down in a visualization in Power BI

 

Best Regards,
Qiuyun Yu