How to switch aggregration using filter

Question

Consider a source file like this&nbsp;Fund, Project, Country, Exposure.&nbsp;My user basically want to views.&nbsp;&nbsp;&nbsp;(1) Aggregrated by Country&nbsp;&nbsp;Country,&nbsp;Exposure&nbsp;(2) Aggregrated by Fund&nbsp;Fund,&nbsp;Country,&nbsp;Exposure,&nbsp;Is there any switch that can help toogle the two views? (Basically (2) is just like more columns compared to (1)&nbsp;Thanks!

idrissshatila · Answer

Hello&nbsp;Anonymous&nbsp;,&nbsp;Yes, check the concept of field parameters&nbsp;https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters&nbsp;If I answered your question, please mark my post as solution, Appreciate your Kudos&nbsp;👍Follow me on LinkedinVote for my Community Mobile App Idea&nbsp;💡

Forum Discussion

How to switch aggregration using filter

1 Reply

Related content

Alternative to SWITCH ()?

Switch -Containsstring

Order switching mid workflow

Using Switch

Switch issues