Forum Discussion

ArvindJha's avatar
ArvindJha
Helper III
1 year ago
Solved

Create line chart without aggregation

Hello Team,   I want to create line chart without aggregation , x-axis show Visit1,Visit2 etc, y-axis should show weight The issue is if a person has two entries for Visit1 the weight gets aggreg...
  • danextian's avatar
    danextian
    1 year ago

    You need to add a dimension that splits those individual weights into different ones. For example, datetimes when the weights were taken which will serve as a group of each individual weight. If you don't have a datetime column, you can add an index column then rank the weight value for each date/person/index.

    Notice that there are two rank valeus for 2/1 in the above screenshot.

    You can add another calculated of invisible characters to be added to the visual so the weights can be split into different categories and not just by date.

    Notice in the screenshot below there is a wider gap for 2/1 as it consists of two rank values

    Please note that another column to X-Axis changes its type from continuous to categorical (continuous can be used only on date, datetime and number data types only). Please see the attached sample pbix.

     

     

  • danextian's avatar
    danextian
    1 year ago

    Addendum:

    If each record regardless if the weights are the same must be shown separately, ranking must be based on the index column

    RANKX (
        FILTER (
            'Table',
            'Table'[Date] = EARLIER ( 'Table'[Date] )
                && 'Table'[Person] = EARLIER ( 'Table'[Person] )
        ),
        [Index]
    )