Forum Discussion

Himanshi0291's avatar
Himanshi0291
Helper II
6 years ago

Line and Stacked column chart

Hi,   I am using line and stacked column chartin power BI desktop. I want that one series of bars should always be still while other can change according to the selection of category for it. Is it ...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

HI  Himanshi0291 

You may try this way as below:

Step1:

Add a dim category table and create a relationship with data table

Step2:

Then create a measure like below:

Measure = IF(MAX('Dim category'[category])="B",CALCULATE(SUM('Table'[Qty]),FILTER(ALLEXCEPT('Table','Table'[Axisvalue]),'Table'[category]="B")),SUM('Table'[Qty]))

Step3:

Now drag category field from this new table into Line and Stacked column chart and category field from basic data table into to slicer.

 

here is a simple sample pbix file, please try it.

 

Regards,

Lin

  • Himanshi0291's avatar
    Himanshi0291
    Helper II
    6 years ago

    Hi

     

    Thank you for your prompt response.

     

    I don't think it is giving me what I am looking for or may be I am not able to do it correctly. Can you by any way help doing that.

      • Himanshi0291's avatar
        Himanshi0291
        Helper II
        6 years ago

        Thank you for the sample data. But, how this can be implemented with my scenerio is difficult to understand.

         

        I think I am not able to explain my problem clearly here so may be a direct converstion would help. Please let me is there any way to connect with you over phone or something. That will be time saving for both of us. Please confirm.