help with line chart and filter

[Anonymous]

hi all,

i got 2 issues in my chart, hope you can advice.

1) in the line chart, how do i get it to show something like this?

2) for the second chart, how do i filter by suppliers?

Thank you very much.

[Tahreem24]

@Anonymous ,

For your reference please see the attached snap shot.

Don't forget to hit THUMBS UP and mark it as a solution if it helps you!

[Tahreem24]

@Anonymous ,

For your first issue, Use Line chart from Visualization pane. And drop the following in property option as below:

Axis --> Month

Legend --> Year

Values --> Numberic field

 What I understood from your second question is to filter supplier in that chart so please take slicer and put supplier column in that slicer.

Don't forget to hit THUMBS UP and mark it as a solution if it helps you!

[Anonymous]

@Tahreem24 

Thanks, I got the first one done.
As for my the second question, my data source only have the value and date.
the orginal source came from a server. how do i add a column with Supplier B in my data?

[Tahreem24]

@Anonymous ,

I am not exactly geetting what are you saying, I apologise for that. But You wanted to create new column in your Supplier B table? is that so ? 

Don't forget to hit THUMBS UP and mark it as a solution if it helps you!

[Anonymous]

@Tahreem24 
yes, to create a new column or perhaps something else.

The end result was to be able to filter by Supplier.

[Tahreem24]

@Anonymous ,

You can create a new column by selecting New Column option from Home menu. And use the DAX formulas to get your expected result.

For better clarity, Can you please share the exact requirement of your new column?

Don't forget to hit THUMBS UP and mark it as a solution if it helps you!

[Anonymous]

@Tahreem24 
if were to add a new column with text "Supplier A", would it be able to use as a filter?

[Tahreem24]

@Anonymous ,

Create new column like below:

Supplier A = "Supplier A"

 

Don't forget to hit THUMBS UP and mark it as a solution if it helps you!

[Anonymous]

@Tahreem24 
I got the column but how to get the filter up?

[Icey]

Hi @Anonymous ,

How is your second chart like? Line chart? 

You need to determine which suppliers these records belong to before they can be filtered.

For example, 

Supplier =
IF (
    SupplierB[Date] < DATE ( 2018, 7, 1 ),
    "Supplier A",
    IF (
        SupplierB[Date] < DATE ( 2019, 1, 1 ),
        "Supplier B",
        IF ( SupplierB[Date] < DATE ( 2019, 7, 1 ), "Supplier C", "Supplier D" )
    )
)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@Icey 
thanks icey.

in my case, i have 3 worksheets and all has the same date from 2014-2016.

is there a way to use the existing file for the supplier filter?

Here the attached file.

https://gofile.io/?c=cOrfYN

Thank you so much.

[Icey]

Hi @Anonymous ,

Try this:

1. Enter a table like below. Without any relationship among other tables.

2. Create a measure like so:

No. of Sales = 
SWITCH (
    TRUE (),
    SELECTEDVALUE ( Supplier[Suppiler] ) = "SupplierA", SUM ( SupplierA[A_No. of Sales] ),
    SELECTEDVALUE ( Supplier[Suppiler] ) = "SupplierB", SUM ( SupplierB[B_No. of Sales] ),
    SELECTEDVALUE ( Supplier[Suppiler] ) = "SupplierC", SUM ( SupplierC[C_No. of Sales] ),
    SELECTEDVALUE ( Supplier[Suppiler] ) = BLANK (), SUM ( SupplierA[A_No. of Sales] ) + SUM ( SupplierB[B_No. of Sales] ) + SUM ( SupplierC[C_No. of Sales] )
)

 

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@Icey 

Thanks, i got it working.

by the way, is it possible to show when supplier A & calendar year is selected, it will show something like this?

[Icey · Accepted solution]

Hi @Anonymous ,

What about this?

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.