Forum Discussion

setis's avatar
setis
Post Partisan
7 years ago
Solved

Chart with data table

Hi All, 

 

Is it possible to add a data table to a chart in power bi like in excel?

 

I've tried adding manually a table with months but it's much wider than the actual chart in PBI

 

9 Replies

    • WillLearning's avatar
      WillLearning
      New Member

      Hi Anonymous, this visual is great but it won't let me display negative values in the chart. The values show in the data table but the Y Axis always begins at zero and I can't find a way to change it. In other similar visuals the start value can be set but not this one, any ideas?

      Thanks

  • jcarville's avatar
    jcarville
    Skilled Sharer

    An alternative method would be to create the column chart but then to view the data table click the 3 dots in the top right of the column chart and select show data. This will open a new window that should give you a similar view to what you are looking, while also saving space on the report.

    • setis's avatar
      setis
      Post Partisan

      Thanks for your answer jcarville,

       

      I had thought about that solution, but I've been asked to prepare a report that will be printed and they want the data table below the chart. 

       

    • Anonymous's avatar
      Anonymous
      Not applicable

      Can we give styling to that table which just occurs when we click on show as table?

       

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi setis,


    I don't think it is possible to do this, there is no option allow you to merge multiple visuals as one visual.

     

    In my opinion, I'd like to suggest you to use r script to manually draw the graph which you wanted.

     

    Regards,

    Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    Have you got this visual in power bi? I have to create clustered chart with data table.
    • setis's avatar
      setis
      Post Partisan

      Anonymous thanks for letting me know. 

       

      I have quicky tested it and it works fine. 

  • Anonymous's avatar
    Anonymous
    Not applicable

     hii setis,can you please help me, how do you create this chart with table in powerbi