nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

What is the Power BI Fund LInk?

Reuben Schmitz

In Power BI, I can connect donors, gifts and Actions to a power BI report using a formula. Is there a similar formula to link to a specific Fund in a Fund report?

I.e., the formula for donors is: CONCATENATE("https://host.nxt.blackbaud.com/constituent/records/",'Constituent(all)'[constituent_id] ) - i create this as a new Calculated column and then link it using Conditional Formatting on the data field in the report

any one have a similar formula for a Fund link?

Find more posts tagged with

Reporting

Microsoft Power Platform

Accepted answers

Alex Wong

Here's the DAX from a BB custom Power BI connector Fund table.

Fund Link = CONCATENATE("https://host.nxt.blackbaud.com/cfa/funds/", Fund[fund_id])

All comments

Carol Grant

I don't know the exact way to use it in Power BI but I do know I can link to a Fund in an email using this path.

https://host.nxt.blackbaud.com/cfa/funds/[FundID]

Or I have a flow that uses this in the email that has the link to the fund.
<a href=https://host.nxt.blackbaud.com/cfa/funds/@{outputs('Get_a_fund')?['body/id']}>@{outputs('Get_a_fund')?['body/lookup_id']}</a>",

Alex Wong

Here's the DAX from a BB custom Power BI connector Fund table.

Fund Link = CONCATENATE("https://host.nxt.blackbaud.com/cfa/funds/", Fund[fund_id])

Reuben Schmitz

Thanks Alex.