show quarter and year trend in graph

[Sriku]

Hi Team,

Need help. I want to show  as per picture as hirerachy. Can any one let me know how to do this:

Regards,

Sriku

[v-lionel-msft]

Hi @Sriku ,

Using the "Drill" feature can achieve the following effects, but it can not fully meet your needs.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sriku]

Thanks Lionel . It is possible by showing hirerachy. But I am looking the same as per screen shot.

[amitchandak]

@Sriku , You can have the year on top and Qtr below in the matrix. You can have that in the table or date table and use it on matrix column.

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

[Sriku]

I tried but in matrix but how to build line chart. can you please build or share some link where i can refer.

Regards,

Srikant

[amitchandak]

@Sriku , you can use legend and Axis for the year and Qtr.