Forum Discussion

KY's avatar
KY
Regular Visitor
10 years ago
Solved

Dynamically calculate differences based on slicer slection

Hi,    I am trying to present the data in a line and clustered column chart,date in the axis, company as column series, and Assets as the column value. In slicer, I have Company (A, B, C....F).   ...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    KY

    Please check if you can follow below steps. To make a better presentation, I'm using some data simple.
    Suppose the dataset is as

     

    1. Create an index column
      rank = RANKX(Table3,Table3[Company],,,Dense)
    2. Create a measure
      Measure = ABS((SUMX(FILTER(Table3,Table3[rank] = MIN(Table3[rank])),Table3[Revenue])-SUMX(FILTER(Table3,Table3[rank] = MAX(Table3[rank])),Table3[Revenue])))
    3. Drag a line and clustered column chart

    Check more details in the uploaded pbix.

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
10 years ago

KY

Please check if you can follow below steps. To make a better presentation, I'm using some data simple.
Suppose the dataset is as

 

  1. Create an index column
    rank = RANKX(Table3,Table3[Company],,,Dense)
  2. Create a measure
    Measure = ABS((SUMX(FILTER(Table3,Table3[rank] = MIN(Table3[rank])),Table3[Revenue])-SUMX(FILTER(Table3,Table3[rank] = MAX(Table3[rank])),Table3[Revenue])))
  3. Drag a line and clustered column chart

Check more details in the uploaded pbix.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Eric,

 

Kudos, that's a great solution. I have similar requirement where i will want to select Base Company and compare company in 2 slicers and show +ve/-ve value depending on the slicer 1 or slicer 2. Can you suggest me any thing to solve this?

 

Thanks

Pramod