Forum Discussion

New Member

4 years ago

Solved

Power BI - Dynamic Report - Adhoc Table

Hello all, I'm looking for a technic to be able to create a fully dynamic table. I'm coming from Qlik and enjoying working with Power BI. I have some users that request (as they have in their old...

Need Help

Tips and Tricks

Tutorial Requests

Burningsuit
4 years ago
Hi TeedoGz

There are many ways of achieving what you want.

You could use the Q&A visualisation, this will allow your users to ask questions like "sum <measurename> and <measurename> by <dimension> as a matrix".

see more on Q&A here ..Use Power BI Q&A to explore and create visuals - Power BI | Microsoft Docs

Or you could create a Matrix visual and then allow the users to personalize the visualisation, which will allow the users to pick other fields in the matrix, or select other dimensions and measures.

see more on personalisation here: Let users personalize visuals in a report - Power BI | Microsoft Docs

These are some of the main ways you can allow your users to create dynamic visualisations.

hope this helps

Stuart

Burningsuit

Resident Rockstar

4 years ago

Hi TeedoGz

There are many ways of achieving what you want.

You could use the Q&A visualisation, this will allow your users to ask questions like "sum <measurename> and <measurename> by <dimension> as a matrix".

see more on Q&A here ..Use Power BI Q&A to explore and create visuals - Power BI | Microsoft Docs

Or you could create a Matrix visual and then allow the users to personalize the visualisation, which will allow the users to pick other fields in the matrix, or select other dimensions and measures.

see more on personalisation here: Let users personalize visuals in a report - Power BI | Microsoft Docs

These are some of the main ways you can allow your users to create dynamic visualisations.

hope this helps

Stuart