Dynamic Value

[Shreeram04]

Hi All,

How to get dynamic value in a visual based on the slicer. If it is measured means I can easily achieve but when it comes to the date column means how can I achieve it.

For Example, I have four column-product, sales date, return date, and order date. If I select sales date in a slicer means its show only sale date value in a visual like wise same for the other two option all done based on product. It shows value dynamically in visual.

Please help to identify a solution for this one. Thanks in advance.

[amitchandak · Accepted solution]

@Shreeram04 , You need explore Power bi Field parameter (May 2022 update)

https://medium.com/@amitchandak/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9a...

[Shreeram04]

Thanks for your reply it works perfectly. One More question supposes if sales data and orders date has come under group 1 and return date plus some more date columns come under group 2. 

When I select group1 in slicer means it will show sales and order dates columns and if I click group 2 means it shows the return date...

How can I achieve this one?. Thanks in advance.

[Shreeram04]

Thanks for your reply.

But on my power bi desktop, I am unable to find filed parameter checkbox. From where I can find it?

Thanks.

[Tahreem24]

@Shreeram04 ,Download latest version of Power BI Dekstop to see that option.