How to pivot all visuals based on a grouped filter

[msham]

Hey good people,

We are aiming to create a high level report with KPIs and visuals that we can then group or pivot based on a selected field. As an example, we have a report on cloud costs and all visuals at the foundational level just report on overall cost (pie chart only shows one slice / stacked columns only show one colour etc). 

However, we want to then have 3-4 fields in a group by filter that when selected pivot the dashboard. For example, in the 'Group By' filter we have; Service, Provider, Environment (these are the column names in the raw data). So when we select Provider, all visuals will be split by Providers Azure/AWS/GCP etc. 

Is there any way we can do this in PBI?

Thanks a lot for the help!

Cheers,
Mike

[TomMartens · Accepted solution]

Hey @msham ,

this is exactly what the feature "Field parameters" is doing.

Here you will find how to create field parameters: Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Regardds,

Tom

[msham]

Hey @TomMartens this is brilliant!! Thanks a lot for the handy tip 🙂 Just a few more questions:

1. Are we able to use this feature in a stacked column graph (e.g. a stacked column chart across 12 months)?
2. Can we restrict the number of fields using the Top N feature?

Thanks again!

Regards,

Mike

[TomMartens]

Hey @msham ,

it's not recommended to ask follow-up questions in the marked answered thread instead open a thread, you can paste a link to other thread and also @people (but pleae be aware that adding people does not guarantee that people will react).

Hence my answer is short:

1. Field parameters work with stacked charts, just add the "field parameter" to the legend of the stacked chart.
2. I'm not sure, check it out

Regards,

Tom