I am new to PowerBI, How to use multi fields in value in Dashboard? Please suggest and that would be very helpful.
Thanks Ibendlin and what do you mean custom visuals, is that in the regular visualizations showing in power BI, how to use and create custom visuals?
Thanks Ibendlin and I get "sunburst" from the market and still no multi fields in value", do you know which custom visual allow multi fields in value?
Thnaks Ibendlin. In dashboard, I can define legend, details, values, in values, can I include multiple fields? I tried, it seems like only one field is allowed.
Based on my test, you can only use multiple value fields if you do not add a field to the 'detail' of the pie chart, or it will prevent you to add more columns to the 'value fields' of the pie chart. (it only allow you to use one value field when you add fields to detail fields)
Notice: this same as other charts in power, the legend/detail field is conflicted with multiple values.
Thanks Xiaoxin, I tried some fields works, some fields not. for example, for some 2 fields, after I add 2 fields into the value, it is showing two fields in the value, but in the final pie chart, it only show the last field I add, not sure why, any idea?
In fact, it will show the values on your pie chart with the split line.
If these two field value amount has obviously difference(e.g. first 10000, second 5), it is hard to find out the second one due to data label unit.
Thanks Xiaoxin, yes I tried it is. if two field value is obviously different, is there any way I can show it clearly, if the small one is hard to find it, it is difficult to show case. Somehow I want to show something like, for year 2018/2019/2020, there are mutiple value fileds such as different product sell, such as apple, orange, tomato, computer, car, so the field value could be quite different.
Yes, the pie chart unit issue should be a trouble when you use the fields with big unit diffs. (It is hard to take the balance of visible and accurate rate of pie chart at the same time)
In my opinion, I'd like to suggest you use some trick to show the percent more clearly.
Create a report tooltip page, which includes a pie chart design by subcategory of the current pie chart. (e.g. my char is design by year and value, the tooltip page pie chart design by month and value)
Then it will display the sub-category pie chart clear than the current one when your mouse hovers on the data bars. (main pie chart show the aggregate result, tooltip page show the detailed percent of current data bar group)
Hope the above can bring you some thought to handle this scenario.
It's not a dashboard, it's a report visual. Depending on the visual type you can add one or multiple fields into the values well. Which visual type are you using?
We are excited to announce the Power BI Super Users!
Overview of Power BI 2020 release wave 2!
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.