Forum Discussion
Do the charts generated by Power BI handle custom interactions
Hello,
I need to know if the charts generated by Power BI can handle custom interactions.
My setup is the following:
- My first tile is a bar chart
- My second tile is simple list (with 5 columns)
Here is what I want to achieve:
- I click on a bar of the bar chart (1st tile)
- I run a new REST query
- The result of that query will be displayed in the list (2nd tile) by replacing the existing content
This is basically what we've done using JavaScript (NVD3) so I need to know if I can reproduce these 3 steps in PowerBI.
Is that possible? Thank you :)
Laurent
Well, I found the solution.. I was just unfamiliar with the Power BI approach.
My solution is to load all possible values in the list.
Then, after setting up some relationships, clicks (filter) on the bar chart will filter the table.
Then I had a problem of how to get the latest data (instead of loading all in one shot). The solution was to schedule Data refresh.
The only cons is I have to load all possible values at the beginning (which in my is totally useless), but Power BI seems to handle it well in terms of performance.
4 Replies
v-chuncz-msftCommunity Support
Let,
As far as I know, it can only cross-filter and cross-highlight the other visualizations on the page.
Well, I found the solution.. I was just unfamiliar with the Power BI approach.
My solution is to load all possible values in the list.
Then, after setting up some relationships, clicks (filter) on the bar chart will filter the table.
Then I had a problem of how to get the latest data (instead of loading all in one shot). The solution was to schedule Data refresh.
The only cons is I have to load all possible values at the beginning (which in my is totally useless), but Power BI seems to handle it well in terms of performance.
- v-chuncz-msft
Let,
To help close this thread, you may accept the solution above. Your contribution is highly appreciated.
Hello,
I need to know if the charts generated by Power BI can handle custom interactions.
My setup is the following:
- My first tile is a bar chart
- My second tile is simple list (with 5 columns)
Here is what I want to achieve:
- I click on a bar of the bar chart (1st tile)
- I run a new REST query
- The result of that query will be displayed in the list (2nd tile) by replacing the existing content
This is basically what we've done using JavaScript (NVD3) so I need to know if I can reproduce these 3 steps in PowerBI.
Is that possible? Thank you :)
Laurent