Forum Discussion

weilip1803's avatar
weilip1803
Frequent Visitor
10 years ago
Solved

Sql data interactions

Currently I have 2 graphs and I want the graphs to be interactive. For example if i click on graph 1 column A i want the graph 2 to make this sql query "A" and if i Click on graph 1 column b i want t...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi weilip1803,

Agree with MattAllington, adding to his post,in Power BI, visualizations on a report page can be interactive by using cross-filter and cross-highlight features. For example, selecting a data range on a clustered column chart highlights the data range on a stacked bar chart, for more details, please check the following screenshots.


Cross-highlight functionality is available in Power BI Desktop and Power BI Service. Cross-filter feature is available in Power BI Service, for more details about how it works, please review the following article.

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-visual-interactions/

Thanks,
Lydia Zhang