Forum Discussion
How to use multi fields in value in Dashboard
Hi Anonymous,
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.
Regards,
Xiaoxin Sheng
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?
David
Hi Anonymous,
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.
Regards,
Xiaoxin Sheng
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.
David
Hi Anonymous,
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.
For example:
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)Create tooltips based on report pages in Power BI Desktop
Hope the above can bring you some thought to handle this scenario.
Regards,
Xiaoxin Sheng