Year trend column chart with a slicer not working.

[BrendaB]

Hi all. 

I have a column chart showing income as a % of sales. I am using the simple calculation "Test = divide([results $],[revenue $])" to populate the chart. My X-axis is "Date>Month" and the Y-Axis is the result calculation. All is fine when I don't use the slicer. See below. 

When I select an option in the slicer, this happens:

I included the other graph to show that it is working properly. Well sort of but that is a different question (my revenue numbers need to stay as negatives and so I inverted the above graph so that they show positive but now all the expenses show inverted...if anyone knows how to display all slicer choices showing the graph upward without changing my numbers, I could use that help too...ha!)

Anyway, question is, why is it not showing the breakdown for this when sliced on the graph? I am guessing my formula for Y is too simple...thanks in advance. By the way...I don't know if this helps? 

[BrendaB · Accepted solution]

I was able to figure it out on my own. In case it helps anyone else, even if it is technically not 'right'...the calculation was a simple one. I was pointed at the incorrect column for the denominator calculation. 

[parry2k]

@BrendaB the one question is not answered, which table you are using to slice on month? Also in the model, I don't see any relationship with the date table. Don't take me wrong, having cross-filter direction to both in the relationship is a BAD idea and can lead to unexpected results and performance issues. And your relationship screenshot has many of those. I don't want to divert the focus from the original problem but I though I should point it out.

[BrendaB]

I did fix my 'inversion' issue by adding an absolute value clause in my measures. One thing solved. 

[parry2k]

@BrendaB which slicer you are referring to? It is not the screenshots? What does your model look like? 

[BrendaB]

Thank you.