Chart title or a message to show when year other than current year is selected.

[LP2803]

Hi Team,

I have a Dim_date table with Year column and i have added this to a slicer. I have a chart which shows the Forecast for Current year.

I want to show the user a message "Forecast is only for current year" when they choose any other year other than 2020 from the slicer and show the chart when they choose year 2020.

Please help me how can i do this.

[nandic]

@LP2803 ,

Here is great step by step explanation: https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/

[LP2803]

Thanks Greg & Fowmy. Both your post helped me to achieve the results. Thanks a lot

[Fowmy]

@LP2803 

You are welcome!

[Greg_Deckler]

@LP2803  - See if this helps: https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Most-Amazing-Mind-Blowing-Dynamic-Slicer...

[Fowmy · Accepted solution]

@LP2803 

Refer to the attached PBIX file which I used to solve a similar problem. 

https://1drv.ms/u/s!AmoScH5srsIYgYJcsC3vs2FM4qh_Aw?e=8J68Wi

If you select Friday the chart will be visible otherwise users are presented with a message. hope you can adapt it to suit your requirement.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn