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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
vinothkumar1990
Helper II
Helper II

New table matrix data

Hi,

I have data in the below format.

vinothkumar1990_0-1669653559661.png

 

I want the report in the below format.

vinothkumar1990_1-1669653599575.png

 

Do we have any visuals which report in this format?

 

Thanks in advance!

 

 

1 ACCEPTED SOLUTION

It worked. Thanks!

View solution in original post

3 REPLIES 3
v-zhangti
Community Support
Community Support

Hi, @vinothkumar1990 

 

The matrix view achieves the results you expect.

vzhangti_0-1669708646088.png

No additional calculations are required.

 

Best Regards,

Community Support Team _Charlotte

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

PaulDBrown
Community Champion
Community Champion

You canuse a simple matrix visual with two measures. First, set up dimension tables for Country and Sales Type using the follwoing pattern in new tables:

Country Table = 
DISTINCT(fTable[Country])

Set up a period dimension table using the follwoing:

Period Table = 
ADDCOLUMNS(
    DISTINCT(
        fTable[Week]), 
        "WeekNum", VALUE(RIGHT(fTable[Week], 2)))

You need the WeekNum field to sort the Week field by:

sort.gifSet up the model using one-to-many, single direction relationships between the dimension tables and the corresponding fields in the fact table:

model.jpg

Create the following two measures for the values bucket in the matrix visual:

Store Sales =
CALCULATE (
    SUM ( fTable[Sales Amount] ),
    FILTER ( 'Sales Type Table', 'Sales Type Table'[Sales Type] = "Store Sales" )
)
Web Sales =
CALCULATE (
    SUM ( fTable[Sales Amount] ),
    FILTER ( 'Sales Type Table', 'Sales Type Table'[Sales Type] = "Web Sales" )
)

Now you can set up the matrix as follows:

matrix.jpgresult.jpg

 

Sample PBIX file attached





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






It worked. Thanks!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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