Interactive Visualization

[Dailey]

Interactive visualization is cool. For example, if you click a bar in a bar plot, you can see the data table behind. But my question is, how to dynamically get that filtered data table and do some other calculations based on that?

[v-juanli-msft]

Hi @Dailey

Welcome to the community!

Would you like to create dynamic dax table which is taking filter from selection in visuals in the report and use this selection to dynamically filter this table?

Calculated Tables ('DAX Tables') are calculated whenever the model is first processed, so they can never be affected by the selection of a visual by a user. 

Best regards

Maggie

[Dailey]

Hi Maggie,

Thank you so much for replying!

But since I am new to Power BI, what function would you suggest I use?

Right now, I hope to get the data dynamically in the table shown below as I choose different bar in the bar plot, but I can only visualize it. 

Best regards

[v-juanli-msft]

Hi @Dailey

You can create a new measure(modeling->new measure), then add this measure in the table visual.

Since a measure can be effect by the content, when the data in table visual is filtered, the result of the measure would be change with it.

See a simple example below.

Measure = CALCULATE(SUM(Sheet1[value]),ALLSELECTED(Sheet1))

Best Regards

Maggie

[Anonymous]

Maggie,

Could you please elaborate a little on your solution.

I wantto know:

- what's "value" in your measure calculation.

- what are you referring to by 'sheet1'

Many thanks in advance

Nn

[Dailey]

Hi Maggie,

Thank you for replying. That can be very helpful.

But I am still wondering, is it possible to save the table as a new variable and that table changes dynamically when we when the data in table visual is filtered?

Since the table behind the bar plot could have already been grouped by and aggregated, I think I may be able to make more sophisticated use of the data if we can do that.

Best regards,

Dailey

[v-juanli-msft · Accepted solution]

Hi @Dailey

As I known, it is not possible to save the table as a new variable. But since you add columns or measures both in the line chart and table visual, when you filter data the line chart, the table would change dynamically with this.

Then you can add measures in the table, since measure would be effected by the context, when the data in the table change, the measure will change along with it.

If you don't want filtering data in the line chart effects other charts but only this table, you can edit interaction with them.

Additionally, you can export the data in the table for further use. (click on the three dot and select “export the data”.

Best regards

Maggie