How to create dynamic report based on selected columns by users

[ravikumarverma2]

Hello,

I am very new to Power BI. I am facing difficulty to create dynamic report.

I have table -

 

I would like to see only the columns as per selection. Suppose If I select only Name and EmpID from slicer or filters, the report should display -

 

Report should be sync with the selection.

Please propose any solution.

[Keerthika]

Hi @ravikumarverma2 
Please refer to the link below
https://www.youtube.com/watch?v=6jeSIRpjv0M
You will find a better idea.

Thanks.

[v-caliao-msft · Accepted solution]

@ravikumarverma2,

Currently, showing dynamic colums on a visual is not support in Power BI report. We can create a measure to show a column value dynamically. Please refer to the link below to see the details.
https://community.powerbi.com/t5/Desktop/Convert-UTC-to-client-time-zones/td-p/56337

However, in your scenario, you need to show multiple columns dynamically, I am afraid there is no a way to achieve it. 

If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,

Charlie Liao