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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Joseph_11
Frequent Visitor

while selecting filters in filter pane it needs to showcase the number of data in a line

Hello All,
Good morning!!

I got a new requirement where user wants to see the repsonse time group that represents as line instead it shouldn't affect the bar datas

Joseph_11_0-1687247686972.png

For Instance: If the user selects response time group from the  filter pane it should need to create a line(as represented in the pic) and the response time group shouldn't interact or affect the bar data.

I wasn't sure whether you are able to get my point.Kindly let me know if any clarity needs. 

In the above pic I have used this measure 

#total_responsetime = CALCULATE(DISTINCTCOUNT('DW FactServiceNow_GSD'[Tickets])+0, 'DW FactServiceNow_GSD'[sla] = "AAGS SAP Response P3") for creating a response time group line...But whenver I select the repsonse time group it alters both the line and the bar data..But in my case this group needs to affect or update only the line representaion and not the bar data.

Kindly let me know the solution

2 REPLIES 2
Joseph_11
Frequent Visitor

@amitchandak Thanks for providing the solution but in my scenario this was not the case.Kindly find the below snip

Joseph_11_0-1687256950255.png

In the above snip, Iam using line and clustered column chart. If the user selects the "AAGS Response".It should need to only interact or update the line(Purple line in the chart) and it shouldn't get interact/update the bar graph(since this has to be done in the same visual it was bit hard).This was the requirements.

amitchandak
Super User
Super User

@Joseph_11 , I think interaction can help you to control, who should filter what.

How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors