Pivot Table with 65 columns

[powerbiexpert22]

Can we create a report with a pivot table containing 1 row and 65 columns in Power BI like shown below ?

[Fowmy]

@powerbiexpert22 
You need to unpivot your data and shape it to a columnar format in order to use it in Power BI:
Here is video on Unpivot:
https://www.youtube.com/watch?v=_YjFGsS9lNY&pp=ygUJZXhjZWxmb3J0

[powerbiexpert22]

Hi @Fowmy

Source data is already unpivoted in excel format, the screenshot attached in the orginal post are for target report ( not source excel) in Power BI. The question is can we create such report in Power BI?

[Fowmy]

@powerbiexpert22 

Okay, you have to use Caluculation Group to achieve the desired layout.

[powerbiexpert22]

Hi @Fowmy 

How would you display the 65 columns in small screen of Power BI? 

[Fowmy]

@powerbiexpert22 

Scrollbars become active the moment the columns increase

[powerbiexpert22]

Hi @Fowmy 

Do you think we should use Power BI Paginated report for this requirement?