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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
goatman
Frequent Visitor

CREATING TABLE WITH DAYS OF THE MONTH AS COLUMN HEADERS

I am trying to create a table with days of the month as column headers. Cant figure out how. Table is as below.

goatman_0-1632746588429.png

Please help, any working suggestions welcome.

2 ACCEPTED SOLUTIONS
vaishnaviudan
Resolver I
Resolver I

Hello,

You can use Matrix visual.

In visual's Fields Panel>> Columns you can put your "Days of the Month" field from table.

Like in given screenshot i have added month no. as column header.

vaishnaviudan_0-1632748998195.png

 

View solution in original post

Thank you Vaishnaviudan for your Quick response.

It is working excellent but need to show month, equipment IDs with respective availabilities. Month is to show the month one is analysing. For example perfomance for june to be indicated somewhere within the matrix like in the sample.

Thank you in advance.

Regards,

goatman.

View solution in original post

2 REPLIES 2
vaishnaviudan
Resolver I
Resolver I

Hello,

You can use Matrix visual.

In visual's Fields Panel>> Columns you can put your "Days of the Month" field from table.

Like in given screenshot i have added month no. as column header.

vaishnaviudan_0-1632748998195.png

 

Thank you Vaishnaviudan for your Quick response.

It is working excellent but need to show month, equipment IDs with respective availabilities. Month is to show the month one is analysing. For example perfomance for june to be indicated somewhere within the matrix like in the sample.

Thank you in advance.

Regards,

goatman.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors