cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Re: Filter issues

Hello,

 

I have appended and combined the Jan and Feb data together. However, the visuals only filter by client on a certain date (ex. jan). However, when I do not select a client on the bar graph I would like to see the total of all clients for just January, but it is not filtering and showing the combined data of both Jan. and Feb.

 

Is there a solution to this?

 

 

Highlighted
Frequent Visitor

Re: Filter issues

Bump

Highlighted
Super User III
Super User III

Re: Filter issues

I'd love to help further, but cannot based on your description or without a sample file. 



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Highlighted
Frequent Visitor

Re: Filter issues

@edhans where can I attach my file for you to take a look at?

Highlighted
Solution Sage
Solution Sage

Re: Filter issues

@joohyo,

 

Upload the PBIX to Dropbox or OneDrive and provide us with the link.

Highlighted
Frequent Visitor

Re: Filter issues

Power BI 1.PNGPower BI 2.PNGPower BI 3.PNG

 

In photo 1 you can see if i click a certain bar on the bar graph it filters by that individual organization as with the other visuals for a certain date in this case January.

 

In photo 2 you can see if I dont click a certain bar (selects all organization) it only filters the bar graph by January date, but the other visuals are still showing both Jan. and Feb when I just want it to show the sum of all organizations for just the Jan data. As you see in photo 3 it shows when I select both dates it shows the same amount of numbers for other visuals from photo 2 

 

@RMDNA @edhans

Highlighted
Super User III
Super User III

Re: Filter issues

I still think you are using the two tables, which you should not. Unload the February table if, like you say, the Jan and Feb data are in the January data.

 



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Highlighted
Frequent Visitor

Re: Filter issues

@edhans The Jan table has both the Jan and Feb data. The visuals are working based off only the Jan table. When I deleted the Feb Table I still get the same results.

 

Thanks.

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors