Dynamic Changing X Axis on Chart based on measure

[mehmetali]

Hello,

I have a hierarchy like the following,

sales regions (20+)

dealers (130+)

sales personnel (300+)

also when people view the report there is rls, and depending on who logged in some people have access to 100+ dealers, and some people have acces to only 1 dealer.

what I wanto to do is, I have a column chart displaying sales information in sales region / dealer / sales personnel detail. I want to change X axis dynamically based on number of dealers in the report. so if someone who has authorization for 2 dealers viewing this report, i want to display this column chart with sales personnel in the X axis (probably 5-6 items). if someone who has authorization for 100+ dealers i want to show the same chart in sales region detail in X axis (probably 9-10 regions). if someone with access to 6 dealers I want to display the chart with dealers on the X axis.

note : I tried field parameters, but couldnt get what i wanted. I thought creating a table and filtering parameter table with this one but it didnt work, because when I create the table, number of dealers is always the same, overriding rls.

kind regards

[lbendlin · Accepted solution]

Add all three levels to the X axis.  Teach your users how to navigate the hierarchy.  Remember that these user choices are persistent across visits unless they "Revert to default" .  Teach them how to work with bookmarks and how to use "Personalize visuals".

[mehmetali]

I don't remember accepting this as a solution. but no problem.

for the people having this kind of problem, I've come across with the video in the link below. with some minor modifications I found the solution.

https://www.youtube.com/watch?v=NqlgTXCfqSs

[mehmetali]

thanks for the reply. but we are talking about 250+ users  which has a considerable turnover rate, from various levels of compentency in terms of IT usage and spending time at their desktop and doing reporting is their least favored thing in their business life.
well at least now I know at least for the moment this is not possible. maybe they work on it on the next update 🙂