We are building a new dataplatform. In this platform we want to create multiple new dashboards. The first few dashboards have aggregated information; the other reports contain all the details.
The structure is as follows:
Report 1 is placed in workspace A, report 1a is placed in workspace B.
Currently we are able to click on the number and that it opens report 1a in another tab; however it does not remember the filters we used in report 1.
Now we want to have the following function: When i click on a number in report 1, i want powerbi to open report 1a in a new tab but remembering the filters i used in report 1.
Are there any solutions for this inconvenience?
You have two options:
For option 2 - You would create a Measure and ensure its Data category
is set to Web URL
. The measure will need to check and see which filters/slicers are set, and then build the URL with the filters. For example:
// set this to the URL of the report WITHOUT any URL filters
Link report 1a base = "https://....."
Link report =
IF ( ISFILTERED(slicerTable[slicerColumn]),
[Link report 1a base] &
"&$filter=Table/Column in ('" &
CONCATENATEX( DISTINCT(slicerTable[slicerColumn]), [slicerColumn], "','") &
"')"
,
[Link report 1a base]
)