Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
11 years ago

Funnel Chart Issue while adding color saturation

Dear Team Power BI,

 

I created funnel chart of top products sales this year. Now I wanted to highlight which product sales have changed over previous year with the help of color saturation option.

 

But when the measure (Change vs last year) is placed in color saturation option, the value of this measure is getting added into the main chart (Actual Sales this year).

 

It seems to be a bug. Pls help.

 

Thanks,

 

Arup Chatterjee

Need Help

2 Replies

  • Amanda's avatar
    Amanda
    Microsoft Employee
    10 years ago

    Hi Anonymous, are you still having issues with this? We have made a few updates and bug fixes since you first posted this, so it is likely fixed. If you are still encountering the problem, would you mind giving us more information? What are the exact steps you are going though. Images are always helpful :smileyhappy:

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      First of all thanks Amanda for looking into this issue. 

       

      The issue still persist. As required I am giving an example with images

       

      The below is Actual Sales by Region in 2015

      Capture1.JPG

       

      Now I am showing separately how was sale in 2015 was higher/lower than last year in below graph

      Capture2.JPG

      As you can see Chandigarh sales 52 more than last year (This year sale - Last year sale). Jaipur & Calcutta declined.

      Now when I put this measure i.e. Rev Chg in Color Saturation option, this value is added to actual sales. i.e 52 is getting added to 488 actual sales of Chandigarh which is BUG. Putting any measure in color saturation should not effect values of other axis

      Capture3.JPG

       

      Pls look into this. This bug is not there in Column charts.

       

      Thanks, Arup