Reply
Regular Visitor
Posts: 22
Registered: ‎12-22-2016
Accepted Solution

How to create a table of contents ?

Hi everyone ,

 

I want to create a table of contents in Power BI.

For example :

1. KPIs

2. Geographics figures

 

When I click on "1. KPIs", I get to the selected tab.

 

=> Is it possible to create a table of contents in Power BI ? (with relations to the tabs)

=> If yes, how to do it?

 

Thanks a lot for your help !

 

Gwendaline


Accepted Solutions
Super User
Posts: 756
Registered: ‎06-03-2016

Re: How to create a table of contents ?

Without publish in services ( cloud) we can't do my dear friend. sorry.

 

but we can do this stuff Tableau and Qlik as well.

 

I hope in feature they will add.

 

Sorry my dear friend. cheers

View solution in original post


All Replies
Super Contributor
Posts: 3,609
Registered: ‎09-27-2016

Re: How to create a table of contents ?

[ Edited ]

Hi @Gwendaline_p,

Based on my understanding, there are  1KPIs and  2. Geographics figures in a table in Power BI desktop, you want to get the relation data when you click on "1. KPIs", right? If it is, we are not able to achieve it. All the data will be displayed when you load it to table.

You can create a slicer, which is used to filter the rows in table. Then create a table visual related to the slicer. When click  any value in slicer, it will return the corresponding values in table.  For instance, when you select the product A, it will only return the result based on product A rows, Please review the following screenshot.

1.PNG

 
If you have any other issue, please share more details.

 

Best Regards,
Angelia

Regular Visitor
Posts: 22
Registered: ‎12-22-2016

Re: How to create a table of contents ?

Hi Angelia , 

 

Thank you for your answer.

That's not exactly what I want.

 

I want a table of contents in a page with 2 things written :

  • 1. KPIs 
  • 2. Geographics figures

I have two more pages : 1.KPIs and 2. Geographics figures with some graph and tables.

 

What I want is : when I click on "1. KPIs" on the table of contents , I arrived on the second page "1. KPIs". It's not related to the data, it's just a relation between pages.

 

For example, in Qlikview : https://community.qlik.com/videos/3026 (at 3.35)

 

Kind regards , 

Gwendaline

Super User
Posts: 756
Registered: ‎06-03-2016

Re: How to create a table of contents ?

I got u.

 

1. If u looking for Global filter it won't work.

 

2. we can do . First u have to publish your report in services . once published get the link from there .

 

 

 

1.JPG

 This is the link for your report first page , like that u can get link for all pages in your report.

 

Based on that link create one table.

2.JPGand u have change the "Data Category" to web URL.

 

Click that and try.

 

 

 

 

 

 

 

 

 

 

 

Regular Visitor
Posts: 22
Registered: ‎12-22-2016

Re: How to create a table of contents ?

Hi Baskar , 

 

Thank you for your help.

 

It's exactly what I want but I can't publish my report, it has to stay on my computer ... I suppose it's not possible ?

I keep in mind your solution if I have to publish my report.

 

Thanks,

Gwendaline

Super User
Posts: 756
Registered: ‎06-03-2016

Re: How to create a table of contents ?

Without publish in services ( cloud) we can't do my dear friend. sorry.

 

but we can do this stuff Tableau and Qlik as well.

 

I hope in feature they will add.

 

Sorry my dear friend. cheers

Highlighted
Regular Visitor
Posts: 22
Registered: ‎12-22-2016

Re: How to create a table of contents ?

Thanks a lot for your help Baskar.

 

Cheers.

Gwendaline

Super User
Posts: 756
Registered: ‎06-03-2016

Re: How to create a table of contents ?

Always welcome my dear friend