Forum Discussion
How to pivot all visuals based on a grouped filter
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
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
3 Replies
- TomMartens
Super User
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
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:
- Field parameters work with stacked charts, just add the "field parameter" to the legend of the stacked chart.
- I'm not sure, check it out
Regards,
Tom
