Forum Discussion

dc189's avatar
dc189
Icon for Helper II rankHelper II
9 years ago

Showing Sales % Growth using Hasonevalue with different slicer value filters

Hello, I have a chart wherein I want to show the Sales % growth by Channel (imagine a bar chart with % growth on Y axis and Online, Retail and Omni-channel on X axis). The % growth should change bas...
Tips and Tricks
v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

dc189,

 

In your scenario, why do you need to use Hasonevalue function? A slicer narrows the portion of the dataset shown in the other visualizations. When no items selected in your slicers, measure will be calcualted  for all the dataset. If you selected some items in Year and Region slicer, the measue will be caluated for the corresponding Years and Regions.

 

If this is not what you want, please provide us some sample data, and elaborate your expected result, so that we can make further analysis.

 

Regards,

Charlie Liao

  • dc189's avatar
    dc189
    Icon for Helper II rankHelper II
    9 years ago

    Hi v-caliao-msft,

     

    Please see link to a sample pbix file: https://www.dropbox.com/s/7jhn76vl5n7v67a/Channel%20Data.pbix?dl=0

     

    Ultimately, I want the user to be able to filter the chart by Year, Region and State and see the growth in online/retail/omni-channel sales for any combination of selected filters. The problem I'm facing now is the chart shows correct values only when Year is filtered but when I filter both Year and Region, the chart shows incorrect values.

     

    How do I correct those values?

     

    Thanks.