Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
KR300
Helper II
Helper II

Dynamic URL's should be active and Clickable after exporting to .pdf format

Hi Team, 

 

I have a URL's : 

1. https://XXXXXXXX.sharepoint.com/sites/DOL-c-US-SMPinfo/SitePages/External-Release-Notes-SFP.R.11.11....

2. https://XXXXXXXX.sharepoint.com/sites/DOL-c-US-SMPinfo/SitePages/External-Release-Notes-SFP.R.11.12....

3. https://XXXXXXXX.sharepoint.com/sites/DOL-c-US-SMPinfo/SitePages/External-Release-Notes-SFP.R.11.13....

 

I have a slicer ( Values:   SFP.R.11.11, SFP.R.11.12, SFP.R.11.13,... ).

I created a dynamic measure which changes based on the slicer value.

 

@questions:

1st Q:  Can we create a dynamic measures in Text Visual in the Power BI?

Ex.,  I have a text Visual   have a word  -  SFP.R.11.11 ( I applied 1st URL on this word )

if i change slicer value to SFP.R.11.12 then the text visual shows SFP.R.11.12  and 2nd URL need to apllied like dynamic ---- is it possible.

 

2nd Q: I am exporting report in .pdf format. after exporting i want those dynamic/Static URL's need to clickable, active and get that URL page.

Whatever URL's used/applied in the text visual & table visual are active, clickable after exporting report in .pdf format.

 

Note: I don't want to show URL in any visual like below

https://XXXXXXXX.sharepoint.com/sites/DOL-c-US-SMPinfo/SitePages/External-Release-Notes-SFP.R.11.13....

 

I just want to apply or USE URL's like    SFP.R.11.12

 

Process 2: I have created a card -- showing a Dynamic text

on the above card visual i place a button for the purpose of Dynamic URL. Here a proble i am facing. the Dynamic URL is working as expected in the Power Desktop & Service but after exporting the report as .pdf format the URL links are not active or not able to clickable.

 

Process 3: I have used dynamic URL's in the table visual but here the visual is the problem by having a Column header. Space of the visual need to be aligned with other visual that would be a manula process.

 

So, What is the best to show Dynamic URL's & Dynamic Text chnages based on the Slicer Values and those URL's must & should be active/Clickable after exporting the report in the .pdf format.

URL.png

 

 

1 ACCEPTED SOLUTION
v-nmadadi-msft
Community Support
Community Support

Hi @KR300  ,
Thanks for reaching out to the Microsoft fabric community forum.
For the first question
 In Power BI, text Visual is static by design and slicer selection will not have any influence on it.
If you want the value to change based on slicer selection then we have to use card visual tied with dax query for that functionality.
Check out this thread for reference:
Solved: Dynamically change text box or card value - Microsoft Fabric Community
For the second question
To get the short link like you are looking for text visual comes in place, but for integrating them both we don’t have a straight forward solution.
I would suggest to raise a request here https://ideas.fabric.microsoft.com/ if you feel your requirement is very important.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards

View solution in original post

2 REPLIES 2
v-nmadadi-msft
Community Support
Community Support

Hi @KR300 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply or let us know how you have resolved and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

v-nmadadi-msft
Community Support
Community Support

Hi @KR300  ,
Thanks for reaching out to the Microsoft fabric community forum.
For the first question
 In Power BI, text Visual is static by design and slicer selection will not have any influence on it.
If you want the value to change based on slicer selection then we have to use card visual tied with dax query for that functionality.
Check out this thread for reference:
Solved: Dynamically change text box or card value - Microsoft Fabric Community
For the second question
To get the short link like you are looking for text visual comes in place, but for integrating them both we don’t have a straight forward solution.
I would suggest to raise a request here https://ideas.fabric.microsoft.com/ if you feel your requirement is very important.

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.