cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

How to show/display slicer selection values in text box/charts dynamically as for title purpose

Hi,

 

Is it possible for me to display my slicer selection values in the labels or text field for title purpose.

 

I want to display my slicer value(filter data) which I selected from slicer into text field or data label or charts. In below snapshot I have selected NEB No Sardegna from Region slicer and DEMEGLIO from Sales Person slicer.

 

Capture.JPG

 

 Now I am trying to show these two selected value to my report like as below in text box automatically. If I changed my filters then text box should be updated automatically based on slicer selections.  Basic aim was I need to display my slicer selections values as title or show in charts dynamically.

 

text lable.JPG

I wanted to know wheter it is possible in power bi. Since I am beginner for power bi. Please guide me how to do this if anyone knows?

 

Thanks in advance.

 

Regards

Sridevi

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: How to show/display slicer selection values in text box/charts dynamically as for title purpose

Hi Sridevi,

 

This blog post from Chris Webb have an exact solution for your problem.

 

Thanks & Regards,

Bhavesh

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

6 REPLIES 6
Highlighted
Community Champion
Community Champion

Re: How to show/display slicer selection values in text box/charts dynamically as for title purpose

Hi Sridevi,

 

This blog post from Chris Webb have an exact solution for your problem.

 

Thanks & Regards,

Bhavesh

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

Highlighted
Helper I
Helper I

Re: How to show/display slicer selection values in text box/charts dynamically as for title purpose

Hi @BhaveshPatel,

 

Thanks a lot for sharing this blog. It was really useful for me. I can do my scripts according to my requirement.

 

Thanks for your help.

 

Regards

Sridevi  

Highlighted
New Member

Re: How to show/display slicer selection values in text box/charts dynamically as for title purpose

I'm interested in a variation on the dynamic text issue, specifically: is there a way to capture the current Hign and Low dates when using a slider as a date range slicer? Not the "is on or after/before" minimum and maximum of the filter, but the current User selected date range.

Highlighted
Helper I
Helper I

Re: How to show/display slicer selection values in text box/charts dynamically as for title purpose

Thanks for the tip but this does not work when I'm editing my Tabular model in Visual Studio, it's as if Visual Studio sees a different version of DAX than PowerBI or PowerPivot does. 

I've come across many formulae that people advise work just fine in  PowerBI or PowerPivot, but when I'm editing my  Tabular model in Visual Studio, they are not recognised.

CONCATENATEX is such an example, 

The Error List advises:  "Failed to resolve name CONCATENATEX. It is not a valid table or function name"

 

 

If anyone can prvide any suggestions or help I'd very much appreciate it

Thanks

Fergal

Highlighted
Community Champion
Community Champion

Re: How to show/display slicer selection values in text box/charts dynamically as for title purpose

Hi @FergalK

 

You can use TabularEditor to write those formulas and Use BISM Normalizer to bring back in SSDT by comparing the models.

 

It is worthwhile to check what compatibility version of analysis services are you using. Is it 2012,2016 or 2017?

 

Power BI has latest DAX features and it might be the case that you are using older versions of SSAS.

 

https://github.com/otykier/TabularEditor

 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
Highlighted
Helper I
Helper I

Re: How to show/display slicer selection values in text box/charts dynamically as for title purpose

thanks Bhavesh, I will check this out

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors