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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Chandrashekar
Resolver III
Resolver III

Graph : Selection with Table

Hello,

 

When click on company name from table graph should show only company name(Hide rest) and week num(last 3 weeks).

Sample Data 

1. Graph should hide all company other than which is not selected in table

2. shows only last 3 weeks data.

Regards,

Chandrashekar B

1 ACCEPTED SOLUTION

Hello,

 

Sorry for late reply. I got the solution. We need to turn on filter in graph.

Chandrashekar_0-1672064242438.png

 

View solution in original post

4 REPLIES 4
v-zhangti
Community Support
Community Support

Hi, @Chandrashekar 

 

You can try the following methods.

Measure = IF(SELECTEDVALUE('Calendar'[Week Num])>=WEEKNUM(TODAY())-2,1,0)

vzhangti_0-1671763217899.png

Is this the result you expect? Only the last three weeks of data are displayed. Hide company names that are not selected.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Hello,

 

Thanks for your reply. Is it possbile to hide axis without Slicer(Company Name).

I was looking to interact data between table and graph. i.e. If company selected in Table only that company name should display in Graph.

 

Regards,

Chandrashekar B

Hi, @Chandrashekar 

 

Can you picture the output you expect?

 

Best Regards,

Community Support Team _Charlotte

Hello,

 

Sorry for late reply. I got the solution. We need to turn on filter in graph.

Chandrashekar_0-1672064242438.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors