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.
I have a table that has Goals for each month:
when I try to put this information into a line/bar chart it gives me either COUNT of SUM the amounts together, and not indiviually.
Which in turn makes the visual look like this:
Is there a measure I can create to have the Totals for each month reflex the amount for that month?
Help is greatly appreciate!
Solved! Go to Solution.
@SteelChampzz 100% bet that you are using Month from your DimCal table and since the cross-filter direction is not Both it is not actually filtering your goal table. Just use Month from your goal table and you're good.
@SteelChampzz So is your visual configured with those two columns in it or are the columns coming from a different table (like a date table)? Maybe missing a relationship?
It's configured with just these two columns in a table, No dates are attached to the table
@SteelChampzz Somethings not correct, see attached PBIX below signature.
The only relationship that is created is to the "Dimdate" table. "Month" relationship.
@SteelChampzz 100% bet that you are using Month from your DimCal table and since the cross-filter direction is not Both it is not actually filtering your goal table. Just use Month from your goal table and you're good.
Greg THANK YOU!
I've been banging my head against the wall with this. You're Awesome!
@SteelChampzz Happens!! 🙂
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |