You've to just edit your parameter to get the desired output. As per my understanding what you want is when you select "Business Unit" then "Segment" should be displayed and when "Segment" then "Level 4 leader" should be displayed. For this just edit your existing parameter like this.
Just create a calc field to show the hierarchy like this and drag it before axis choice in row shelf.
Let me know If this help.
Hi, actually, I'm wanting it so that if the user selects anything other than viewing all of the business units, the axis automatically changes to show just the segment. Normally I would want the list of 8 business units shown when the user lands on the page.
The ask is, If and only if I choose to view less than all business units, all segments are displayed.
Then if and only if I choose less than all business units and less than all segments then level 4 leaders are displayed. But my curiosity is if I can do this automatically. The instant that a user selects to see just his business unit (Say paper clip manufacturing) then the axis automatically switches from showing a list of business units to the various segments of paper clip manufacturing.
I gave the first two examples to show that there are already things I can do. My curiosity is if I can get rid of a step for my users.
Thanks for thinking about it!
I tried this statement which makes us of if then and logic but its still not grouping the 'all' even if you try to trick it with every field in the dimension business unit.
and [Business Unit] = 'Operations'
and [Business Unit] = 'Services' then [Business Unit]
elseif [Business Unit] ='Finance' then [New Segment]
elseif [Business Unit]= 'Operations' then [New Segment]
Elseif [Business Unit]= 'Services' then [New Segment]
I know I'm close, I just have to capture an 'All' function when it doesn't exist in the field. I am going to see if I can load all in the parameter