Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I have two dates with data. Whenever I filter by one month it still shows as the total of all the months on the cards and other visuals. Is there a way to fix this issue? Thanks.
When viewing my report after I publish it, a random filter is activated. It's not locked so wondering why it's active. It's a problem becuase I'll have to tell everyone to clear that filter before reading the report. Help.
Looks like it's working now! No filters are activated when publishing which is what I need.
Always do this @Anonymous
That should mean your end user has the report with no selections set.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingBump
I'd love to help further, but cannot based on your description or without a sample file.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting
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
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting@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.
@joohyo - without knowing too much about the data in your tables, it would seem to me those two tables should be one table.
If they came in through Get Data, rather than loading those two tables, create an Append Query in the Query window to merge the two tables into one, then uncheck "Enable Load" on the two source tables.
I am assuming the two tables are identical data but two different months of it (January sales, February sales) for example.
That will eliminate your issue of crossfiltering.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting@edhans Hello,
What I did was I had a January table and then used the get data I have imported the February table. Then I used the appended function to insert the February data into the January table. Each time I filter just by January (or just february) it filters properly on just one client, but does not filter as the total of the entire client.
If the January table has Jan+Feb data, then you don't need the Feb table to be checked for "enable load"
What might be happening is your feb data in the visuals is being pulled from the Feb table and that will cause the issue you are seeing, as those tables aren't related, and really cannot be related.
I'd back up your PBIX file just in case because this could trash some of your visuals, but back it up, then go to the queries and uncheck "enable load" for the Feb table and save that.
Now all of your data should be in the Jan table if you did the append, and crossfiltering should work.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingHello,
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?
Hi @joohyo,
Did you use any measures? What's the formulas?
Best Regards,
Dale
Hello Dale,
I am fairly new to PowerBi and do not know how to set up formulas or measures. Will that solve the issues? If so what needs to be done?
Thanks,
Joo
do you have a relationship between those tables? if you dont that could be causing that issue
I have also appended my data from the February data into the January data therefore, it is technically one table.
Hello Hasan,
I am fairly new to PowerBI. What are relationships and how should I form them?
Thanks,
Joo
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |