04-19-2018 08:17 AM - edited 04-20-2018 05:26 AM
I want to show all months and one custom category created from Month called Quarter values like "Q1" to "Q4"
I want to show these two columns Month and Quater in custom bargraph
By default, it should all months and when the user select Q1 from the drop down it should show something like this in the graph i have attached. Any ideas
how can we do it?
Thanks In advance
04-20-2018 01:51 PM
04-20-2018 02:18 PM
Yes, It does not work.
for example, if I select Q1 from drop down It should group all months of Q1 like in image 1 . and if i will uncheck the q1 option. It should show all the months like Jan-18,feb-18,Mar-18 etc. image 2
04-25-2018 07:09 AM
Make sure you have two category variables one for quarter and one for month.
Then create a parameter that will contain the value from the drop-down (example: The drop-down contains two values Quarter or Month)
Create a new calculated item that check the value of the parameter and then select which category variabel to use, example och calculation:
IF [parameter] = 'Quarter' then quarter
Use this new item as category in your graph.
In your example you have two different graphs and that is not possible since you can not change visualization upon a value in a list box.
Am I somewhat on it?