Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
admin11
Memorable Member
Memorable Member

Should i use Straight or Matrix table for YTD vs LYTD ?

Hi All

I freq using table to compare YTD vs LYTD , May i know usually people here prefer to use Striaght or Matrix table ?

admin11_0-1618232199628.png

 

1 ACCEPTED SOLUTION

Hi @admin11 ,

 

If you have more than three levels in hierarchy, you will not see total value in the middle level in table visual.

 

Best Regards,

Dedmon Dai

 

 

View solution in original post

7 REPLIES 7
v-deddai1-msft
Community Support
Community Support

Hi @admin11 ,

 

As for me, I would like to use the matrix when I have a lot of hierarachy in data or I need to view data in different levels in hierarchy.

 

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

 

Best Regards,

Dedmon Dai

@v-deddai1-msft 

May i know for striaght table able to support hierarachy ?

Hi @admin11 ,

 

If you have more than three levels in hierarchy, you will not see total value in the middle level in table visual.

 

Best Regards,

Dedmon Dai

 

 

@v-deddai1-msft 

I just try to create stright table with hirechy it is not possible. So now i see the value in matrix

aj1973
Community Champion
Community Champion

@admin11 

Both are good, why do you need to chose?

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

@aj1973 

I think there are pro and con , for example i think Matrix table for sorting YTD column is not so easy vs striaght table.

aj1973
Community Champion
Community Champion

@admin11 

When you build visuals you need to Know/think like a User and how the user is going to like it not you.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.