The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 ?
You may try to adjust the measure and take advantage of Visual level filters.
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.
User | Count |
---|---|
5 | |
2 | |
2 | |
2 | |
2 |
User | Count |
---|---|
11 | |
7 | |
5 | |
4 | |
4 |