How to plot bar chart on amount by Brand_C ?

[Anonymous]

Hi All

I have a table which compute slow moving items , i like to plot the chart for those items in red box.

Bar Chart On Hand Amt By BRAND_C ? 

https://www.dropbox.com/s/02xhd8hz3wz6p3r/PBT_V2021_89%20filter%20more%20then%203%20year%20not%20mov...

My PBI file 

Paul

[amitchandak]

@Anonymous . In visual level filter add Amt_on_hand >0

[Anonymous]

Hi Amit

Thank you for your advise , but it is possible for you to advise me how to plot the bar chart for those on hand amt >1 by BRAND_C ?

[Anonymous]

Hi @Anonymous ,

Please check whether the below screenshot is what you want, you can find the details in the attachment. 

1. Create a bar chart: Axis: BRAND_C  Values: Amt_On_Hand

2. Set the visual level filter for the bar chart: Amt_On_Hand>1

Best Regards

[Anonymous]

Hi Ying

Thank you for help me create the bar chart , but that chart is overall stock amount include those slow moving items. what i need is plot the slow moving items amount only. 

https://www.dropbox.com/s/yndpb9ji83wb13p/PBT_V2021_89%20filter%20more%20then%203%20year%20not%20mov...

my PBI file at above link

[Anonymous]

Hi @Anonymous ,

It is due to missing the filter "_SLOW_NEW=1" in bar chart when compare to the table. Please create a calculated column to replace the original measure [_SLOW_NEW]. You can find the details in the attachment.

_0SLOW_NEW = 
IF (
    TODAY () - INVC[Last Sold Date]  > 3 * 365
        &&  INVC[Last Sold Date]  <> BLANK (),
    1,
    0
)

Best Regards

[Anonymous]

Hi Ying

I try to duplicate your bar chart to my actual PBI file , i can not get it plot amount by Brand_C.

My PBI file :-

https://www.dropbox.com/s/ridyiangg754crt/PBT_V2021_103%20ask%20how%20to%20plot%20slow%20moving%20it...

Paul

[Anonymous · Accepted solution]

Hi @Anonymous ,

I updated your sample pbix file(see attachment), please check whether that is what you want.

1. Create a calculated column Column_SHOW_NEW_Y as my previous post

Column_SHOW_NEW_Y = 
IF (
    TODAY () -   INVC[Last Sales]  > 3 * 365
        &&  INVC[Last Sales]  <> BLANK (),
    1,
    0
)

2. Create a clustered column chart(Axis: BRAND_C  Values: Amt_On_Hand) and add visual-level filter(Column_SHOW_NEW_Y=1)

Best Regards

[Anonymous]

Thank you very much for your help , it work fine now.

[amitchandak]

@Anonymous , Try this measure

sumx(filter(values(Table[model]), [Amt_on_hand]>0),[Amt_on_hand])

[Anonymous]

Hi Amit

Thank you very much , it work fine now.