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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors