Forum Discussion
Solved
Bar chart bringing back too many columns
Hi, I'm trying to create a Revenue by Month bar chart against a budget: I'm happy for the budget to be across the whole financial year; however, I have the slicer on my page set to F...
Hi,
I ended up creating a second date table with no relationships between the data tables - this solved the problem as I could use keep the interaction between the slicer and graph, use SELECTEDVALUE and it not filter to one month only.
bhanu_gautam
Super User
Super UserConnorCrawford , Try using
DAX
Revenue by Month =
CALCULATE(
[Margin],
REMOVEFILTERS('Date'),
FILTER(
ALL('Date'),
'Date'[Period] <= SELECTEDVALUE('Date'[Period])
),
Actuals[PL Type] = "Revenue"
)
Thanks for the reply,
However, this has created cumulative months rather than removing the column on March: