Change Y axis on Button Selection.

[marial16]

Hallo experts,

I am building a report and i was asked of the following.

We need to have 2 buttons one should Diplay Count and other should display SUM .

Initialy i added 2 cards for this purpose and created bookmarks for it. However since i also have two bar charts and a Table on this Report, i was asked on Button selection to be able to change values on Y axis or X axis of the Bar Charts respectively and also this should apply on the table visual as well.

For the following visual i have Open Quantity on Y axis and Month on X axis. 

if i select the SUM button i want the Y axis to change and Display the Sum of Open Quantity

I have seen a couple of videos on Dynamic axis, however i am not sure which is the best approach for this implementation.

Can i use those buttons to change values on a Table?

Open Quantity is a whole number field 

[selimovd · Accepted solution]

Hey @marial16 ,

I would try the field parameters that exist since the update a few days ago:

https://docs.microsoft.com/de-de/power-bi/create-reports/power-bi-field-parameters

Would that be an option?

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic