cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mehmetali
Frequent Visitor

Dynamic Changing X Axis on Chart based on measure

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

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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".

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

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".

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 🙂

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.