Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello, i want to show a chart which shows the volumes of YTD (starting 1st April) going back in time. so for today it would shows
Bar 1 - 1st April 2024 - 21st April 2024
Bar 2 - 1st April 2023 - 21st April 2023
Bar 3 - 1st April 2022 - 21st April 2022
Solved! Go to Solution.
same logic for each bar you want to display
Dax Measure:
Volume from 1st April 2024 to 21st April 2024 =
CALCULATE( SUM(YourData[Volume]),
DATESBETWEEN(
Date[Date],
DATE(2024, 4, 1),
DATE(2024, 4, 21)
))
pls try this
Proud to be a Super User!
i would just like to flag 1 in the column, not display a date. thanks for your help
then try this
Proud to be a Super User!
how would i calculate these values
same logic for each bar you want to display
Dax Measure:
Volume from 1st April 2024 to 21st April 2024 =
CALCULATE( SUM(YourData[Volume]),
DATESBETWEEN(
Date[Date],
DATE(2024, 4, 1),
DATE(2024, 4, 21)
))
Hello,
You can use a clustered column chart. Calculate the values for each bar in separe DAX and choose the order you want for display
User | Count |
---|---|
129 | |
73 | |
70 | |
58 | |
53 |
User | Count |
---|---|
190 | |
97 | |
67 | |
62 | |
54 |