PBI Chart visualization design with combination of quarter and month

[JWick1969]

Hi,

I have a requirements in PBI to combine quarter and months in one visualization. I'm not sure if this kind of visualization is feasible.

I'm looking at the net and i can't find any sample to be use as my reference. Is there any simlar approached that i can be used  based on my sample. Thank you.

[amitchandak]

@JWick1969 , refer my technique of show all . I have brand all table, in place of that; have a table with all month name as months name and month names with qtr name

Each month will repeat once for month and once for qtr and then you use it in the same way I have done for grand total

https://amitchandak.medium.com/power-bi-add-grand-total-row-in-the-bar-visual-44c3d1d463be

if needed create a sort column 

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

[JWick1969]

Hi @amitchandak , This is what i did to my table. I created a datekey table with 2 columns one is a date format the the other is a Year_Qty format. Then just relate the table to main Date table. when i used the new created column and the result i got, they have the same values on different month. see sample below.  

[JWick1969]

Hi Amit, Thanks for the reply. I cant figure out on how to to this using the one you mentioned.  it's okay if you can provide me a sample using small data and the desired result? 
By the way, I have a  date table  with column for Month name and Qtr. How How can i combine this into one column. sample below.
 Month_Qtr
Jan-22
Feb-22
Mar-22
April-22
May-22
1-2022
2-2022
3-2022

[JWick1969]

@amitchandak . thanks. i already use the technique you shared. my only question is how can i put an space btween the QTR and Month (with color yellow), so that they can easily identify. please see sample below.