Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi, I have 02 column chart to see the total of per date,day or per hour.
how to get the sum value by filtering because the measure I make shows different value.
thank you in advance..
My table:
Date | Day | Time | Sample | Total |
1-Aug | Tue | 12:00:00 AM | Item 1 | 325 |
2-Aug | Wed | 12:00:00 AM | Item 1 | 315 |
3-Aug | Thu | 12:00:00 AM | Item 2 | 340 |
4-Aug | Thu | 3:00:00 AM | Item 2 | 285 |
Date | Day | Time | Sample | Total |
1-Aug | Tue | 12:00:00 AM | Item 1 | 325 |
2-Aug | Wed | 12:00:00 AM | Item 1 | 315 |
3-Aug | Thu | 12:00:00 AM | Item 2 | 340 |
4-Aug | Thu | 3:00:00 AM | Item 2 | 285 |
1-Aug | Tue | 3:00:00 AM | Item 1 | 10 |
1-Aug | Tue | 6:00:00 AM | Item 1 | 200 |
1-Aug | Tue | 9:00:00 AM | Item 1 | 200 |
Example I select date from Aug 1 and Aug 2 @ 12:00am
I want the Item 1 value to show as 325 and 315.
@jayceeb Please Can share your Endoutput in a table or on the chart? Thank You.