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 am implementing a bar chart with a line. The bar chart is based on values from Table A and sums number of calls by month:
There is a separate Table B that contains # of surveys returned (here is a sample):
FY21 Oct 5
FY21 Nov 1
FY21 Dec 2
The 2 tables are connected via the same year/month (for example ... FY21 Oct). The Table B values are giving sum as a flat line:
The visual line needs to show specific months (here is an example of another visual):
Is there a way for yellow line not to be a flat sum line? Can a measure of some type be used?
Thank you in advance for your review!
Hi @luvagoldenk9 ,
Please refer to my pbix file to see if it helps you.
Create a measure.
Measure =
CALCULATE (
SUM ( 'Table (2)'[mnvalue] ),
FILTER (
ALL ( 'Table (2)' ),
'Table (2)'[date] = SELECTEDVALUE ( 'Table'[date] )
)
)
If I have misunderstood your meaning, please provide your pbix file without privacy infromation and desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@luvagoldenk9 , You should use a common FY /Date table, There you should have these FY Month columns. Join with both tables, Use the common table on axis
Try to be in star schema
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
Hello amitchandak!
Thank you for your quick response.
Unfortunately that did not seem to work as I received the same results. Perhaps I missed something:
Table A is a details table and contains details about each call (call date, name, issue, etc.)
Table B is a summary table and only has totals by each month so:
FY21 Oct 5
FY21 Nov 1
FY21 Dec 2
The visual seems to be summing all of the Table B values and the line is representing the total number of surveys instead of each individual month.
Thoughts?
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 |
---|---|
110 | |
109 | |
89 | |
76 | |
66 |
User | Count |
---|---|
126 | |
112 | |
99 | |
82 | |
73 |