Forum Discussion

wi11iamr's avatar
wi11iamr
Icon for Advocate II rankAdvocate II
10 years ago

Select dimensions to dynamically add to chart - much like a pivot chart

I'd like to try and make a chart where the end user is able to select which dimension or measure they wish to see in the chart. For example, let's say I'm showing the budgeted expenses per month, bu...
Need Help
ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

wi11iamr In power bi service create a group and add your users to that group. You can choose edit rights for the selected users in that group. Then in power bi desktop create measures and publish reports to that group. Your users can now edit the standard report and add measures (you created) to chart they like. 

 

I don't think or is aware of such visual yet which will let you drag and drop fields. You can also consider using drill down in charts so that your measures are one level below standard, and your users drill down to see for the measures but I don't think that is what you want. Creating groups way is your best bet i think.