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
mehaboob557
Resolver IV
Resolver IV

Need to show values as columns

Hello All,

 

I am having data like

 

status demo.PNG

 

I want the status values as column names and count below the respective column status values. 

 

I mean,    

   

       Version 1.0

Draft| Published| Confirmed

2         1                3

1          2                1                                     

___________________________

3    |    3            |  4                 (total)

 

      Version 2.0

Draft| Published| Confirmed

2         1                3

1          2                1

___________________________

3    |    3            |  4                 (total)

 

I want to get each version has how many drafts, published, e.t.c

 

Please suggest me how can i get.

 

Thank you in advance.

 

 

 

1 ACCEPTED SOLUTION
bsas
Post Patron
Post Patron

Hi,

 

Try to play with matrix visual.

View solution in original post

2 REPLIES 2
bsas
Post Patron
Post Patron

Hi,

 

Try to play with matrix visual.

Thank you 🙂

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.