Forum Discussion

ambreenshaikh's avatar
ambreenshaikh
Regular Visitor
5 years ago

Qtr

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    
Need Help
AlexisOlson's avatar
AlexisOlson
Super User
5 years ago

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

ambreenshaikh's avatar
ambreenshaikh
Regular Visitor
5 years ago

How to make separete visual please ?

 

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    5 years ago

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

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi  ambreenshaikh ,

     

    Check my .pbix file attached.

    Best Regards,
    Kelly

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