Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Show multiple lines on slicer selection

Hi,

 

Requirement is when i multiselect CI060 and CI118 ,then it should show two lines one for CI060 and other for CI118 .Likewise  bars for both CI060 and CI118.It shouldnt sum the both selection values .Please let me know how to do this in Power BI

 

PBIX file  : PFA pbix file

 

Thanks

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous I was thinking:

    Cl060 = SUMX(FILTER('Sheet3',[MS Code]="Cl060"),[Actual])

Cl118 = SUMX(FILTER('Sheet3',[MS Code]="Cl118"),[Actual])

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    Anonymous Any chance you can create 2 measures, one for each? This has come up before in a different thread and this couldn't happen because there were about 120 possible values. If you can, put both measures in Line Values. I'll try to dig up the thread.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Greg_Deckler 

       

      I have created below measures.Its not working when i'll do multiselect from slicer,

      CI060 = IF( LASTNONBLANK(Sheet3[MS Code],1)="CI060",IF( ISFILTERED(Sheet3[MS Code]), CALCULATE(SUM(Sheet3[Actual]),Sheet3[MS Code]="CI060"),BLANK()))
      CI118 = IF( LASTNONBLANK(Sheet3[MS Code],1)="CI118",IF( ISFILTERED(Sheet3[MS Code]), CALCULATE(SUM(Sheet3[Actual]),Sheet3[MS Code]="CI118"),BLANK()))
       
       
       

       

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        5 years ago

        Anonymous I was thinking:

        Cl060 = SUMX(FILTER('Sheet3',[MS Code]="Cl060"),[Actual])

Cl118 = SUMX(FILTER('Sheet3',[MS Code]="Cl118"),[Actual])