Forum Discussion
Power BI value
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
4 Replies
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
Thanks for your reply. Can you please explain how this will work?
What does the index column do?,
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 👍
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
