cancel
Showing results 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

Helper I

## How to display different scale in one matrix visual

Hi,

I have a table which contains week and date (not always the starting day of the week) as below

 ID week date 001 W428 7/10 002 W429 7/15 003 W430 7/24 004 W431 7/29

And I have created a matrix, ID as row, week as column, count of ID as value.

 ID W428 W429 W430 W431 001 1 002 1 003 1 004 1

Now I want the matrix to display part of weeks, and the last week show in date form

 ID W428 W429 W430 7/28 7/29 7/30 7/31 8/1 8/2 8/3 001 ...

1 ACCEPTED SOLUTION
Super User

@syuu , First create a date table

DateTable =
CALENDAR (DATE(2022, 7, 1), DATE(2022, 8, 3)),
"Year", YEAR([Date]),
"Month", MONTH([Date]),
"Day", DAY([Date]),
"Week", WEEKNUM([Date], 2) -- Week starts on Monday
)

Create relationship with your table using date column

Then Create a matrix visual , Drag ID column to Rows, Week column form main table to Columns and ID column to values and set it to count

Drag the Date column from the DateTable to the Columns field in the matrix visual.
Ensure that the Date column is placed after the Week column in the Columns field.

 Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!

Super User

@syuu , First create a date table

DateTable =
CALENDAR (DATE(2022, 7, 1), DATE(2022, 8, 3)),
"Year", YEAR([Date]),
"Month", MONTH([Date]),
"Day", DAY([Date]),
"Week", WEEKNUM([Date], 2) -- Week starts on Monday
)

Create relationship with your table using date column

Then Create a matrix visual , Drag ID column to Rows, Week column form main table to Columns and ID column to values and set it to count

Drag the Date column from the DateTable to the Columns field in the matrix visual.
Ensure that the Date column is placed after the Week column in the Columns field.

 Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors