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

How to create a link to another page in same report?

Hi,

 

I am using Power BI Desktop. I want to create a link to reference dictionary in the report page. This link when clicked should take the user to that page. The idea is that report page is quite filled and is using abbreviations. I want to give user an option to see what those abbreviations mean by creating the reference dictionary on a separate page.

 

Alternatively if there is a way to hover the mouse on the abbreviations, if user can see what they mean that would be great as well. The abbreviation and its full name are coming from the database table. I am using SQL Server. Any help is appreciated. Thanks.

1 ACCEPTED SOLUTION
Community Support
Community Support

Hi

Drillthrough filters may help!

In the page which is quite filled and using abbreviations, apply the drillthrough filters with the reference dictionary as here,

then click on the page and select ‘drilltrough’, you will navigate to the dictionary page.

Additionally, there is a workaround, add the dictionary field to the tooltip, then the data point referring to abbreviation field will show the information from dictionary.

If you have any question, please feel free to ask me.

Best Regards

Maggie

View solution in original post

1 REPLY 1
Community Support
Community Support

Hi

Drillthrough filters may help!

In the page which is quite filled and using abbreviations, apply the drillthrough filters with the reference dictionary as here,

then click on the page and select ‘drilltrough’, you will navigate to the dictionary page.

Additionally, there is a workaround, add the dictionary field to the tooltip, then the data point referring to abbreviation field will show the information from dictionary.

If you have any question, please feel free to ask me.

Best Regards

Maggie

View solution in original post

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors