Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Trying to create a bar chart which should show entire data for dimension [Month Year] if there is no selection for [Month Year] and selected fields with user input.
Can anyone suggest a if case which can be done.
Thanks, Rahul.
If you simply use
Month Year as dimension
SUM(Sales) as an expression..
This should work..
Can you elaborate on selected fields with user input? Can you share actual dimensions, measure expression, sample data, expected output? you will get faster responses over here.
Trying to display [Month Year] with Sum(Sales) in a bar chart, if the user selects any [Month Year] it should just display those selection for [Month Year] if not it should should all the available data set for the [Month Year]
Does this explain?
Something like
if(GetSelectedCount([Month Year])=0,{1<[Month Year]>},[Month Year]).
Please excuse my set analysis, trying to learn 🙂
If you simply use
Month Year as dimension
SUM(Sales) as an expression..
This should work..