Forum Discussion
Page level or report level filter
If you see below image, in that case I have to create a new column for everytime when I will create a some chart or graph and have to add that code, is that so? Year and State selection is either one or more. but my requirement is like, is nothing selected then, nothing will show on graph, all graph or charts should blank, so once year and state selected, it will start populating the value.
Yes, you will have to create explicit measure to be used in each visual.
Hi Greg,
thanks for replying, but i am not looking only one selection, I am looking atleast one selection. When I created a new column with given code, but when i m going to the report, value is not populating in that, it is remaining blank, even if i select year and any state.
sagarpsali, I'm unclear on your requirement now. Do you want to enforce exactly 1 year and >=1 state?
- Hi,
My requirements is like if at least year and one state should be selected then only it will show graph. So there are chances that user can select one year or more and same for state. But need here is, to show some graph, user has to select at least one year and one state. Now what is happening, even if there is nothing selected either year or state, graph/report considering all input and showing the result.
Here one more question to me, when report will load, either by default all values from year and state should preselected and then user can decide which to select. If u see the diagram which I uploaded, it has select all option is there for states, if user click that "Select All" states get deselected. And even though, graph showing value. So when nothing is selected from state or year , none will appear on report. As soon as user will select at least one year and state, it should refect in graph.
I hope u understand my question.