Forum Discussion

OrenAiz's avatar
OrenAiz
New Member
3 years ago

keeping values in line chart when using slicer

Hi,

 

I have created a line chart with a market share of ~10 suppliers.

I want to exclude the small suppliers and keep the values of the rest top 2 suppliers.

when I exclude the small ones, the market share of the rest 2 has been changed:

 

before using the filter:

 

After filtering:

 

 

Need Help

3 Replies

  • Mikelytics's avatar
    Mikelytics
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Hi,

     

    Please try the following measure

     

     

    New Measure =

CALCULATE(
   [your current measure],
   ALL(
      'the table or your suppliers' or ['the column with the suppliers which you use in your chart']
   )
)

     

     

    Best regards

    Michael

    -----------------------------------------------------

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

    @ me in replies or I'll lose your thread.

  • OrenAiz's avatar
    OrenAiz
    New Member
    3 years ago

    Thanks for your prompt answer.

    What do you mean when you write "your current measure"?

    • Mikelytics's avatar
      Mikelytics
      Icon for Resident Rockstar rankResident Rockstar
      3 years ago

      Can you please show what you put in the chart? so the content of the panes on the right