Hi Folks,
I think i can't be the first one to encounter this problem.
I've got a report, usually based on months, so my x-axis of most visuals is something like 01-22 02-22 etc.
So now if my user selects a single month out of my column Monthname via slicer, all visuals will show a single bar, point and so on.
So, I want to change the x-axis day-based.
For this, I worte two measures:
First, I get the destinct count of my Months for the slicer. If theres only one monthname, count will be one, if there is more than one monthname, it will be another number.
Anzahl Monate = Distinctcount(KALENDER[Monatsname])
After that, I wrote another measure, which is a switch-statement based on what number my first measure gives back:
Datumsswitch =
var selectedmonth = [Anzahl Monate]
return
SWITCH(selectedmonth, 1, SELECTEDVALUE(Kalender[Datum]),"Fehler Datum",
12,Selectedvalue(KALENDER[Eindeutiger Monat], "Fehler Monat"),
"Mehrfachauswahl")
So, basically, what I'm trying to do is: If the count of monthnames is one, select the Date-Coloumn, if its 12, select the Month-Coloumn, if its anything else give back "Multiple selections"
It works pretty fine with the defaults, but it's not giving back any of my dates.
I know I made a mistake somwhere on the way, but I don't get the clue where I made it. Could you please give me a hind?
Kind regards
Sammi
