Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Oggie
Frequent Visitor

Drilldown from Custom rows in Profitbase Financial reporting model

Is it possible to make custom rows clickable (for exempel Gross profit) in Profitbase so that other visualizations are filtered?

1 ACCEPTED SOLUTION
dm-p
Super User
Super User

Power BI only creates selectors (IDs to handle interactivity between visuals) for the rows it sends. For successful interactivity, a visual would have to assign a suitable selector to a custom data point that Power BI could understand in the context of the data it originally sent (as a custom visual cannot directly communicate with other visuals on the page; just ask Power BI to try to filter them based on one or many IDs identifiable from the received dataset).

 

Based on this premise, it is highly likely that Power BI wouldn't know what to do, unless the logic in the visual tries to assign or accumulate selectors based on the original source data. As Profitbase is a closed-source visual, it's not possible to tell what they do here without asking them directly.

 

Your best bet would be to use Profitbase's official support link on their AppSource listing (which links to a GitHub repo where users can raise issues for bugs or discussions for feature requests) and ask them your question.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




View solution in original post

1 REPLY 1
dm-p
Super User
Super User

Power BI only creates selectors (IDs to handle interactivity between visuals) for the rows it sends. For successful interactivity, a visual would have to assign a suitable selector to a custom data point that Power BI could understand in the context of the data it originally sent (as a custom visual cannot directly communicate with other visuals on the page; just ask Power BI to try to filter them based on one or many IDs identifiable from the received dataset).

 

Based on this premise, it is highly likely that Power BI wouldn't know what to do, unless the logic in the visual tries to assign or accumulate selectors based on the original source data. As Profitbase is a closed-source visual, it's not possible to tell what they do here without asking them directly.

 

Your best bet would be to use Profitbase's official support link on their AppSource listing (which links to a GitHub repo where users can raise issues for bugs or discussions for feature requests) and ask them your question.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.