Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
Hi,
I have the following requirement:
I have 2 report pages:
Page 1 has a table visual like the following:
Page 2 has a set of visuals, which will be filtered based on selection of value on Page 1 (Linking Report Page 1 and 2)
When I click on any value from Column Cars on Page 1 eg. Audi , I want the Page 2 to open with visuals filtered for Audi.
Is this possible?
@
@vanessa Really interesting...Not sure if fit your needs but here it goes ( think is cool functionality )
I have only test it so it might need some tuning.
Reports can be filtered on the url., so create a calculated column in the source of the first page table ( i.e Car Brands ). Then you copy the 2nd report url and you add at the end the filter of brands
Filtered Report = "https://app.powerbi.com/groups/me/reports/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx?filter=CarBrands/Brand%20eq%20% & CarBrands[Brand] & %27
Where xxxxxxxxxxxxxxx is the code from your report link - CarBrands/Brand = TableName/ColumnName
%20 is space , %27 is ' .
The actual format of the filter parameter is ?filter=CarBrands/Brand eq 'Audi' and this is what we trying to manage. Get the Audi depending the value in the table.
Usually it works like that but sometimes is better to write it with url formating for spaces etc ( 20% )
Notice - the names of tables and columns cannot have spaces.
You can check these links
http://stackoverflow.com/questions/35555694/passing-parameters-to-power-bi-filter-programmatically
http://mmaitre314.github.io/2016/02/13/passing-report-filters-to-power-bi-using-urls.html
Now the easy part, you add the url column in your table and then go to table attributes and set url icon to On.
Now your table will look good also as when you click the url icon you and up in the filtered page report. There you can add a link to take you back to the first report with the Brand table.
I hope I make it clear enough.
Are you suggesting hardcoding the value like Audi in the URL?
Also, how will the visuals in Page2 be filtered based on this URL?
I am a little confused.
@vanessa Sorry but I didn't had time to add it ti pbix so I can expain more.
I will try to find time to expain..
For now 1. PowerBI reports can filtered based on url if the url contains the value of a table/column.
2. Not exact hardcoded on the calculated column - it depends on the values of the Brand column.
To test it try to copy in txt the report page url and add ?filter.... ( follow the previous post instructions) hardcoded the "Audi" for example. You will see that the reports is filtered on Audi.
I will try to make a more detailed post later. Sorry
People smarter than me can jump in, but when i need to bridge filtes across pages, I use Report Level filters which you can find in the values editing pane on the right side of Power BI Desktop. Users access it on PowerBI.com by expanding the filter section on the right.
I know this is not the same UI and experience you are likley seeking, but it is the route I have found that works for users.
Best, Scott
That is one way, you could also just put slicers for on page 2. I don't know that you want to necessarily force the navigation to page 2, based on a selection or click. What if a user wants to explore the data within page 1, based on the Audi selection? They couldn't, becuase they would be forced to move to page 2.
To answer your question directly, I am not aware of any out-of-the-box features that facilitate that type of behavior.
Good luck,
Nate
User | Count |
---|---|
118 | |
66 | |
65 | |
56 | |
50 |
User | Count |
---|---|
182 | |
85 | |
67 | |
61 | |
53 |