Forum Discussion

tusharsharma's avatar
tusharsharma
New Member
7 years ago

Dynamic x and y axis depending on slicer selection

Hi, 

 

I have segregated my dataset for a list of firms into decile sets and there are seperate decile sets for depending on the performance parameter. For e.g - if there is a decile set wherein the firms have been segregated depending on their revenue in 2017. 

 

I want to create a bar chart where the x axis displays the decile and the y axis has the values for the average value of parameter selected in the slicer. So, if I change the parameter using a slicer, the set of firms in each decile will change and the values displayed will be the average values of parameter selected in a particular decile. 

 

I have been able to change the y axis dynamically  but not the x axis. Can someone help with this ? 

2 Replies

  • tusharsharma's avatar
    tusharsharma
    New Member
    7 years ago

    Hi,

     

    I have decile data for a set of firms depending on different parameter. For e.g for parameter A, the set of firms in a perticular decile is seperate. 

     

    I want to develop a bar chart in which the x axis displays the deciles and the y axis will give average value of performance parameter for the set of firms in that particular decile. Both the axis wil change depending on the parameter selected in a slicer. 

     

    Can you suggest a workaround for this ? I have been able to create a chart with dynamic y axis but have not been able to change the deciles on x axis depending on the parameter selected.