cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Visuals interactions - filtering using a specific fields only

Hello,

 

I would like to have interactions between Line Chart and Pie chart → when I click on Line chart bar, Pie Chart will show % share of elements.

The problem is, that the measure in line chart is a 'Value' column with filtered specific 'Type' column.

But the Pie Chart should show % share of items other than the one showing on the Line Chart for specific Month.

 

How to achieve that? I understand the default logic, that the filtered 'Type' item in Line chart is not present on Pie Chart, and the result is a blank chart if I click on specific month. But is there any way to make it work?

 

Visuals before I click on Month bar:

{84599083-E1E4-42A7-916B-9BB6E382AE3D}.png.jpg

After I click specific month, Pie Chart disappears:

{C99B0537-F106-4A68-BF67-22984D14B181}.png.jpg

1 ACCEPTED SOLUTION

@v-shex-msftI've tried to replicate  visuals to send you a file, but it worked well. Checked again my report and after analysis it was an issue with data source 🙂 It's a pity I lost some time trying to configure visuals.

 

Please delete this topic if possible as it will not have any value for any users at this community 🙂

View solution in original post

4 REPLIES 4
Community Support
Community Support

HI @mat_k,

AFAIK, you can't custom on visuals interaction filters.

In my opinion, I'd like to suggest you use measure formula to replace default value fields, you can add if statement to check if current content is blank and return specific calculation result.

Can you please share a sample pbix file for test? It should help to test and coding formula.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

@v-shex-msftI've tried to replicate  visuals to send you a file, but it worked well. Checked again my report and after analysis it was an issue with data source 🙂 It's a pity I lost some time trying to configure visuals.

 

Please delete this topic if possible as it will not have any value for any users at this community 🙂

View solution in original post

Super User IV
Super User IV

Check have you used fill interaction or filter interations

Interactions.png



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

@amitchandakit does not matter in my case, any type of interaction gives me blank data on the Pie Chart after I click on month bar on Line Chart.

The problem is

- Line Chart includes only one Item from 'Type' column

- Pie Chart includes all items from 'Type' column except the one used in line chart

 

So after I click on the bar, I want to Pie Chart show me % share of the all other items, excluding the one which is on the Line Chart.

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors