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
DevM01
Helper I
Helper I

Creating a new table and use in visual not getting filtered

I created a new table where I grouped entries in the original data source, then I used this table in a filter. Now I have a slicer and am using this slicer in my page, and it's filtering all other visuals except for this visual that is using the table in its values. Is this normal? How can we fix it?

8 REPLIES 8
v-jayw-msft
Community Support
Community Support

Hi @DevM01 ,

 

Do you have an active relationship between these table?

Please try to create a relationship with 'year' column and see if the problem was solved.

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Anonymous
Not applicable

Maybe the is nothing to filter ? You could create another visual (not the pie chart) to check what the details of the pie chart and see if its wrong or not.

 

Without some details and pictures i wont be able to help anymore. Bacause of the lack of info and details I am basically guessing what the problem can be

Anonymous
Not applicable

Sorry dont get it

 

My simple table

 

remyo_0-1606402572205.png

 

My PieChart

 

remyo_1-1606402608814.png

 

You want slicers ?

remyo_2-1606402685202.png

 

Hi @Anonymous I have a slicer already for the year, to filter years. Now when I filter based on the years, it filters other visuals on the page, but it doesn't filter the visual I created from the new table. 

Anonymous
Not applicable

Then i think we would more info.

Your data model and some sample data would help

 

@Anonymous So my data model includes these values: 

AccountID, Region, Budget, Year

Account ID is not unique, so it can be repeated. I want to group by all account IDs, then show a pie chart representing all regions. So what I did was creating a table with this formula: 

 

NewRegions = GROUPBY(reqs, reqs[AccountID], reqs[Region])

This gave me a table with all regions grouped by account ID. I added this to a pie chart where legend = Region and Values = Count of Region

 

I think it's not filtering because I didn't include the year with the GROUPBY formula since my new table doesn't include a year column, so I changed my formula to this: 

 

 

NewRegions = GROUPBY(reqs, reqs[AccountID], reqs[Region], reqs[Year])

 

But it didn't work as well with the filtering, moreover the data coming like this is wrong, since I have around 3 entries for each AccountID and now I have the number of records X 3. 

 

 

Anonymous
Not applicable

Select the visual from which you are selecting

Go To Format in your Ribbon

Select Edit interactions

If the stop sign is turned on the interaction between the visuals is disabled. Enable it

@Anonymous which visual? the slicer or the visual where I have the table? I selected both, and disabled the stop sign on both, nothing happened. 

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.