Dynamic parameters histogram

[Emmy88_]

Hi all,

I am trying to get a dynamic histogram showingcasing either plan volume by Plan UM or LY volume by LY UM.

I have structured my data as follows;

However the histogram isnt showing data when i use the parameter UM as values, does anyone know how to tackle this?

Thank you,

Emmy

[nandic]

Hi @Emmy88_ ,

There are a few ways to show dynamic values.
1) use bookmarks - just duplicate the chart, create bookmarks and then choose which chart is visible on which selection
2) field parameters - https://www.youtube.com/watch?v=-nqEv2YXLsU
3) create dynamic measure which is checking by which dimension user is showing data. Example:
If isfiltered(column1,sum(columnX),sum(columnZ)) 

Cheers,
Nemanja Andic

[Emmy88_]

Hi Nemanja,

Thank you for your message. Im afraid i did not formulate my questions clear.
I am searching for a way to make the dynamic measure for underneath histogram visual work.

The Plan view is working as the values are based on a column within the plan fact table:

The LY view is not working as I believe the LY value is based of a measure:

Therefore If I want to add a parameter for the values with 1 being Plan and 1 being PY the visual is not working.
Would you know of a workaround?

Thank you,

Emmy

[Anonymous]

Hi @Emmy88_ 

Power BI does not have a built-in histogram visual, what is the custom histogram visual you are using?

Moreover, could you please provide some sample data.

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.