Forum Discussion
Measure taking on invalid values
- 2 years ago
Sorry for the misunderstanding jetform_consult.
At the moment what is the behaviour on the Month graph? Can you provide a print? I couldn't understand from your explanation
Best regards,
Jorge Pessoa
Thank you Jorge for your response.
Unfortunately, this is not what I am attempting to do. I only switched to a table to try to get an understanding of what was happening.
What I am trying to do is to have 2 graphs superimposed on top of each other. One graph will have MONTH values and the other graph will have the values for the date contained in [SelectedDate]. When no date is selected, my other measure (OrdersByCalendar_DTL[CNT Time(SUM) per Period]) is Blank(). If you select a date, [SelectedDate] takes on that value and OrdersByCalendar_DTL[CNT Date(SUM) per Period] takes on a value.
This is supposed to make one graph ALWAYS show Blank() values and allows you to "seemingly" switch between 2 different graphs...One for the entire month, and the other for just a single day.
This use to work until I changed my date slicer from a PowerSlicer to a PivotSlicer because of other issues with the PowerSlicer.
What I want is the following:
No Date selected...Should show the entire Month
When you select a date...The Month graph should be flooded with Blank() values making it transparent to reveal the TOD graph beneath it.
Sorry for the misunderstanding jetform_consult.
At the moment what is the behaviour on the Month graph? Can you provide a print? I couldn't understand from your explanation
Best regards,
Jorge Pessoa