Forum Discussion
Dynamic Hyperlink Buttons Based on Selection
Hello Team, I am looking for some creative advice! Concept - I created a master spreadsheet that is on SharePoint that I added all of our report direct links to each report and names, etc to so...
Thank you for all the help, sorry for the delay just remembered I wanted to give my thanks :).
I have a table and when users select the first 12 rows in a filter for the report name column, the buttons light up white as active basically in order alphabetically and work on click to take you to the report and then the buttons that are past the selected say which button is inactive and show as inactive.
So in short, a custom user interface that we have a full list coming from Excel of all of the reports we have in PBI and a hyperlink in each row. Then the below works from that using the above logic etc.
Dynamic Button 1 Color =
IF(
ISBLANK(CALCULATE(
VALUES('Master Links Dashboard'[Report Name for Button]),
FILTER(
ALLSELECTED('master links dashboard'),
RANKX(
ALLSELECTED('master links dashboard'),
'Master Links Dashboard'[Report Name],
,
ASC,
Dense
) = 1
)
)),
"#999999","#FFFFFF")
(Have a shortened name column for the button text to always fit)
DynamicName =
CONCATENATEX ( ALLSELECTED ( 'Master Links Dashboard' ), [Report Name], "," )
Report Link 1st Row Selected =
CALCULATE(
VALUES('Master Links Dashboard'[Report Link]),
FILTER(
ALLSELECTED('master links dashboard'),
RANKX(
ALLSELECTED('master links dashboard'),
'Master Links Dashboard'[Report Name],
,
ASC,
Dense
) = 1
)
)
ConditionURL =
IF (
ISFILTERED ( 'Master Links Dashboard'[Report Name] ),
SELECTEDVALUE ( 'Master Links Dashboard'[Report Link] )
)