Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Graph year and quarter

Hi I need help with the following: I have already a column (see below Year & Quarter (text)) when I add to shared axis "Year & Quarter" is only showing Q1 and the a sum up of all Q2, Q3, Q4 in the graph instead of the following example: 

Please help

2006 Q1 

Q2

Q3

Q4

2007 Q1

Q2

Q3

Q4

2008 Q1

Q2

Q3

Q4

2009 Q1

and so on...

 

7 Replies

  • Anonymous , please share a better sample data

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • Anonymous's avatar
      Anonymous
      Not applicable

       

      2006 Q1 

      Q2

      Q3

      Q4

      2007 Q1

      Q2

      Q3

      Q4

      2008 Q1

      Q2

      Q3

      Q4

      2009 Q1

      and so on...

      instead of below image (instead of 2006 Q1, 2006 Q2, 2006 Q3.... only 2006 Q1, Q2, Q3, Q4, 2007, Q1, Q2, Q3,Q4....) Please help

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        amitchandak 

         

        right now shows like this

         

        it is supposed to show all years in the order of 2006 Q1, Q2, Q3, Q4, 2007 Q1, Q2, Q3, Q4, 2008 Q1, Q2, Q3, Q4, 2009 Q1, Q2, Q3, Q4, 2010 Q1, Q2, Q3, Q4...AND SO ON until 2021 Q1, Q2, Q3. 

         

    • Anonymous's avatar
      Anonymous
      Not applicable