Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to use multi fields in value in Dashboard

Hello,

 

I am new to PowerBI, How to use multi fields in value in Dashboard? Please suggest and that would be very helpful.

 

 

Many thanks.

 

David

 

 

Need Help

14 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    Power BI Dashboards don't have fields (and not much interaction).  What are you trying to achieve?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks Ibendlin and I have clarified my question in the post.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.

    • lbendlin's avatar
      lbendlin
      Super User
      5 years ago

      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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        I am using Pi chart, is multiple fields possible in the value?

         

        Thanks

        David

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    No, but there are custom visuals of that type that allow more than one value field.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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?

      • lbendlin's avatar
        lbendlin
        Super User
        5 years ago

        Click the ellipsis (...) In the visuals area, add visual, from market.