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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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?

9 REPLIES 9
LittleMarie
Frequent Visitor

I have a similar problem. I've created a linked table in power query, grouped in by and then created a visual table on the board. And all the page's filters do not work with this new table. I've check the iteractions in the Format, everything is on.

In the end, I had to create dimentional tables, relate them to the major and grouped tables and create new filters based on these dimetional tables.

Anonymous
Not applicable

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

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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