Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Displaying different values from the same column for one day

Hi everyone! A stupid question but how does one go about plotting several different values from one column vs a given corresponding date?         What it does now it sums up Planned Depth...
  • Thejeswar's avatar
    Thejeswar
    5 years ago

    Hi Anonymous ,

    I am able to achieve this but with a workaround.

     

    Instead of using the Value column in Value secution of Line chart also use it in the legend and make the summarization of the one in the value column to max.

     

    Then hide the line by making the stroke width to 0.

    Switch off the tooltips and enable the data labels.

     

    The Same power bi report is present in the below link. Do check out

    https://1drv.ms/u/s!Ahd9tZ6Q55jygSTRO1r4iC-wTsVP?e=VchwKP

     

    The Below is the screenshot of the final output

     

    Mark it as a solution and give it a kudos if this helps!!!

     

  • v-kelly-msft's avatar
    5 years ago

    Hi  Anonymous ,

     

    Create a column as below:

    rank = RANKX(FILTER('Table','Table'[Data]=EARLIER('Table'[Data])),'Table'[VAlue],,ASC)

    Then put the column in the legend of line chart and you will see:

    For June 4,2021,it has 2 values,and they are all shown in line chart.

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!