Replicate Tableau report into power bi

[kalyan209]

HI Guys,

   I am new to Power BI and want to replicate the below tableau report into power bi. But i could not find a graph which does this excactly in power bi. 

Any suggestions would be really helpful .

thanks,

kapil

[Anonymous]

Hi

Did you try the matrix visual? 

More information is needed on your tableau report

Thank you

Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.com

[kalyan209]

Hi,

I tried using matrix visual and it does not let me use multiple columns as seen from the image.

it lets me use only one column.

does this have method to add multiple columns?

thanks,

kapil 

[PaulDBrown]

@kalyan209 

I'm not sure what you mean by the table / matrix visualisation only allowing "one column". Judging by your image, you have a dozen columns; both the table and matrix visualisations can have that number of columns (and many more if needed of course).

So what exactly is the issue you cannot solve?

Thanks.

[kalyan209]

Hi

I want something similar to the image below with the values in the last. But when i use matrix chart in power bi i am able to get the "Classification of Observation" values and only one column for instance "TRN". 

i would like to have all the columns in the image.

Thanks,

kalyan

[PaulDBrown · Accepted solution]

@kalyan209 

Sorry, I must be particularly obtuse this evening. 

Here is a sample table. The columns in Blue come from tables; the columns in red come from measures. There is no limit to the number of columns you can include (well there probably is, but certainly not anywhere near the dozen you need)

[kalyan209]

In power BI I get it this way when using a matrix chart. I would rather want all the columns beside each other

Thanks

[alena2k]

Try this: go to the Format of your Matrix, find 'Row headers', switch 'Stepped layout' to 'Off'.  After that you need to expand to the last level, but you will have all columns next to each other.

You can protect your final report from 'Drill-up'.

[Anonymous]

Hi

In the Matrix visual, when you add multiple fields it will tread them as a hierarchy that you can drill. Changing from a Matrix to a table it will display all of the side of the field by side.

+ sign is showing you that you can drill down.

If I answer your question, please mark my post as a solution, this will also help others.
Please give Kudos for support.

Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.com

[Anonymous]

Hi

If the table or matrix visuals do not allow what you are trying to do, I will try to check the custom visual import.

A. Click the "..." in the visualization selection

Look for Custom Visual to ImportSelect Import from MarketPlace

If I answer your question, please mark my post as a solution, this will also help others.
Please give Kudos for support.

Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.com

[kalyan209]

I tried checking but could not find anything similar to what i need.

stuck with this view.