Qtr

[ambreenshaikh]

Hi 

i need to show in column Months from Jan to Dec, I can do this by using the Date,  I needed to put Qtr after the Months, Is there way of doing it please , Please see Picture below

[AlexisOlson]

You want to add the quarter columns into the same matrix visual? This is possible but it's much less work to create a separate matrix for the separate granularity.

[ambreenshaikh]

Yes sir, i want to add the Quarter Column into same matrix visual,  This is requirement from top management

[AlexisOlson]

If you must, you must.

This StackOverflow post may be useful.

[ambreenshaikh]

I dont get this ,  Any help with this regard will be appreciatd,   Is there any easy way please 

[AlexisOlson]

There is no easy way. That's why I recommended a separate visual instead of building a new dimension table.

[ambreenshaikh]

How to make separete visual please ?

[v-kelly-msft]

Hi  @ambreenshaikh ,

Check my .pbix file attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[AlexisOlson]

The same way you make the first one. Put two matrices side by side, one with months for columns and one with quarters instead.