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
Marcin86
Frequent Visitor

Filtering a chart by another table containing parts of a word in a column.

Hi, 

I have problem with filtering chart by table contain unifid value.

Example data:

Marcin86_2-1686038500845.png

I am looking for a way to use table 2 to filter the chart (based on table 1).
The chart shows the sum of the Number column for a given month.

 

I can do to filter the tables but I have a problem with the chart.

Thanks

 

sorry for my english 🙂

2 REPLIES 2
Marcin86
Frequent Visitor

It's almost good, but how to handle all the selected ones?

v-yangliu-msft
Community Support
Community Support

Hi  @Marcin86 ,

 

Here are the steps you can follow:

1. Create measure.

Flag =
var _select=SELECTCOLUMNS('Table2',"1",[Region])
return
IF(
CONTAINSSTRING(
MAX('Table'[regionCode]),_select)=TRUE(),1,0)
Value =
    SUMX(
    FILTER(ALLSELECTED('Table'),  YEAR('Table'[Date])=YEAR(MAX('Table'[Date]))&&MONTH('Table'[Date])=MONTH(MAX('Table'[Date]))),[Number])

2. Place [Flag]in Filters, set is=1, apply filter.

vyangliumsft_0-1686190367353.png

3. Result:

vyangliumsft_1-1686190367356.png

 

Best Regards,

Liu Yang

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

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.