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
RicardoDL
Regular Visitor

Matrix in PowerBI in the same way Tableau does it

Hi there

 

In Tableau I can create a matrix in a view by using the measure names and measure values pills to bring out multiple different measures in one matrix. I can also specify different formats for the different measures and display them in that way. How can i achieve the same in PowerBI, I do not see a way to do this unless I manipulate the datasource which I cannot do on a published data set?

1 ACCEPTED SOLUTION

Yes you can create seperate measures with differnet format.
you can change format type from measure tools present in data view.

Dhairya_0-1684415751035.png

and then place all your measures in matrix.

Dhairya_1-1684415833989.png

more accurately you want date on columns like this

Dhairya_2-1684416089622.png
Dhairya_3-1684416183647.png

 

I hope i have answered your question correctly!

View solution in original post

4 REPLIES 4
Dhairya
Solution Supplier
Solution Supplier

You can use ISINSCOPE dax function to do calculations on heirarchy level and also format their display values.

you can refer following videos:
https://www.youtube.com/watch?v=926alfqFhMs

https://www.youtube.com/watch?v=sSUCyps_1O4

Please mark my solution as accepted if i have aswered your query!

So this is not exactly what I meant, I have placed an example of what i mean below,

 

Tableau allows you to place multiple different measures in one visual, I can have my date series go across my X axis and then the different measures on my Y axis

RicardoDL_0-1684414821539.png

This way i can achieve a simple table to display for a quick view of figures for stake holders

Yes you can create seperate measures with differnet format.
you can change format type from measure tools present in data view.

Dhairya_0-1684415751035.png

and then place all your measures in matrix.

Dhairya_1-1684415833989.png

more accurately you want date on columns like this

Dhairya_2-1684416089622.png
Dhairya_3-1684416183647.png

 

I hope i have answered your question correctly!

Thank you, my issue was my formatting, under Values then Options there is the option to turn columns to rows

RicardoDL_0-1684417180867.png

Your screenshot above lead to this

Helpful resources

Announcements
Europe Fabric Conference

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 Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 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