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 Line and Column Chart visual on my report. The column data show's current year visits for the last week and the line chart shows prior year visits during the same time period last year. On the x-axis I have Day-Of-Month and the y-axis is the sum of total visits. During the middle of the month the visual looks great. But at the start of the month the visual doesn't work(see image below). Any ideas on how to avoid this? Do i need to do something with the sort order or is it a configuration thing?
In my date table I have the following measures created to pull last weeks data and PY last week:
Last_Week = Dim_Date[Date] >= Today()-8
PY_Last_Week = DIM_DATE[DATE] >= TODAY()-373 && DIM_DATE[DATE] <= TODAY()-366
And then in my visits table I have these measures created:
Week_TotaL_Visits = CALCULATE(SUM(VW_VISITS[TOTAL_VISITS]),DIM_DATE[Last_Week] = TRUE())
PY_Week_Visits = CALCULATE(SUM(PY_VISITS[TOTAL_VISITS]),DIM_DATE[PY_Last_Week] = TRUE())
This is how the visual should look when working:
This is how the visual looks at the beginning of the month:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |