Power BI value

[PPStar]

Hi

I have a sharepoint list which stores some Number values, e.g. Column A, Column B wil store the values 10, 12

If i connect my power bi report to sharepoint list and place a Line and Clusterd Column chart, i am unable to place the Value which implying its a MAX value. 

If i have two values that are the same in sharepoint, e.g. below

Column A    | Column  B 

10                | 14

15                | 12

The graph will show the MAX of column A. How can i have it so it shows the actual value of column A without haivng to show it as the MAX. 

Hope that make sense. 

Thanks

[Idrissshatila]

Hello,

Instead of clocking on the max, click on the sum in the screenshot you provided.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[PPStar]

can you please elaborate how clicking on the sum is the solution?. I dont want the sum of values. I want the 'actual' values without having to put MAX

[amitchandak]

@PPStar , For that you need add index column, and you have add index column to the visual also

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

Power Query- Index Column: https://youtu.be/NS4esnCDqVw

[PPStar]

Thanks for your reply. Can you please explain how this will work?

What does the index column do?,