Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a simple inline Table
Cost_Rev:
LOAD * Inline [
Name
'Supply East'
'Revenue West'
'Supply North'
'Revenue West'
];
I have two selectors pane:
First Selector pane will display all the values,
Field: "Name": will display all the values
in the second filter if I have to display only "Revenue" fields, so I wrote the below condition to display.
Field: =aggr(Only({<Name={"*Revenue*"}>}Name),Name)
Which will display only Revenue, works fine.
The problem is that the second filter not automatically getting selected when you select from the first filter
i.e When I make the selection in the first filter, the second filter is not turning in to green selection, rather it's having a white selection (filtering properly).
For the testing, I have changed the condition to the field name "Name", which works with the "Green Selection"
Can anyone please help to resolve this issue
Make sure to use Filter pane from chart, and not drag and drop. (worked for me)
Make sure to use Filter pane from chart and then assign dimension, and not drag and drop the dimension from 'Fields' which will create an automated pane.
works for me:)