How to create Custom Columns

[hbirdie]

Hello,

I hav

 

Hello,

I need my report to look like the 2nd screen shot from the 1st screen shot. Basically, column 2 should be listed horizontally and column14 vertically only in the 1st column along with its counts. Has anyone created a report like this?

Thanks in advance.

Hormuzd

[rajulshah]

Hello @hbirdie,

Can you please share sample data?

[Anonymous]

Hi @hbirdie

Use Matrix visual to get this.

Thanks

Raj

[hbirdie]

Hi @Anonymous,

I tried but no luck. Is there a step by step tutorial?

Thanks

HB

[Anonymous]

A simple google search will bring you hundreds of guides 🙂 here is the one for ex:

https://docs.microsoft.com/en-us/power-bi/desktop-matrix-visual

Thanks

Raj

[hbirdie]

Yes. I saw this earlier. It is not exactly what I need.

[v-yulgu-msft]

Hi @hbirdie,

It is not possible to get the expected result completely. As there are only three columns in 1st screenshot, while the highlighted data does not exist in sample data.

So, what is your desired output with the provided sample table? Is any calculation needed to get required result?

Regards,

Yuliana Gu