cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shreeram04
Resolver I
Resolver I

Dynamic Value

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.

1 ACCEPTED SOLUTION
4 REPLIES 4

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.

Thanks for your reply.

 

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

Shreeram04_0-1654585548405.png

 

Thanks.

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

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors