Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 ...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    Anonymous , First create a date table

    DateTable =
    ADDCOLUMNS (
    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.

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

Anonymous , First create a date table

DateTable =
ADDCOLUMNS (
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.