I have a slicer that is in date format and works perfectly fine with all other visualizations on my power bi page.
I have an area chat visual. I want to show CY and PY revenue on the same area chart visual.
CY =
SUM(Table[Revenue])
PY =
CALCULATE(
SUM(Table[Revenue]),
SAMEPERIODLASTYEAR(SUM(Table[Revenue]))
)
If this wont work using a slicer, that's fine I can disable my area chart from the slicer. However, I do I get both y-axis (CY & PY) to show simultaneously?
I have an area chat visual. I want to show CY and PY revenue on the same area chart visual.
- The area chart visual shows 2 dots when I remove the x-axis
- The area chart visual shows 1 dot when I add the x-axis
- The area chart only shows primary y-axis correctly when disabled from the date slicer but does not show secondary y-axis at all.
- Here my DAX for CY & PY - They both work
CY =
SUM(Table[Revenue])
PY =
CALCULATE(
SUM(Table[Revenue]),
SAMEPERIODLASTYEAR(SUM(Table[Revenue]))
)
If this wont work using a slicer, that's fine I can disable my area chart from the slicer. However, I do I get both y-axis (CY & PY) to show simultaneously?