Forum Discussion

Karthik12's avatar
Karthik12
Post Patron
3 years ago
Solved

Customized bar graph

Hello Team,

I have production date till today which have date and production qty.

I would like plot a month wise bar graph (Month vs production qty) for this year (Jan and Feb 2023).

But,

I would like have customized date selection for Jan, Feb and also coming month.Such a way, From Jan 1 to Jan 27 production date should be come in Jan month and from Jan 28 to Feb 24 should come in Feb month.Like I have different dates for Mar to Dec.

 

Is there any possibility?

 

 

 

 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Karthik12 ,

    Please try below steps:

    1. below is my test table

    Table:

    2. add a new column with below dax formula

    Adjust Date =
VAR cur_date = [Date]
VAR _val =
    SWITCH (
        TRUE (),
        cur_date >= DATEVALUE ( "2023/01/01" )
            && cur_date <= DATEVALUE ( "2023/01/27" ), DATEVALUE ( "Jan 2023" ),
        cur_date >= DATEVALUE ( "2023/01/28" )
            && cur_date <= DATEVALUE ( "2023/02/24" ), DATEVALUE ( "Feb 2023" ),
        cur_date >= DATEVALUE ( "2023/02/25" )
            && cur_date <= DATEVALUE ( "2023/03/31" ), DATEVALUE ( "Mar 2023" )
    )
RETURN
    _val

    3. add a bar chart with fields

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    3 years ago

    Hello Karthik12 ,

     

    In the case you should add a calculated column with an if and else statement specifiying that from this date to this date name it January else if its from this date to this date name it Feb and you continue, then you use this column when visualising.

     

    If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

    Follow me on Linkedin

    • Karthik12's avatar
      Karthik12
      Post Patron
      3 years ago

      Hi,

      Thanks for the hint.

      Here am attaching my data model pbix file. Can you share the DAX codes ?

       

       

      Jan 2023 - from 01-01-2023 to 27-01-2023

      Feb 2023 - From 28-01-2023 to 24-02-2023

      Mar 2023 - Fro m 25-02-2023 to 31-03-2023

       

      Thanks in advance for your support !

       

      Customized monthly bar graph.pbix

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Karthik12 ,

    Please try below steps:

    1. below is my test table

    Table:

    2. add a new column with below dax formula

    Adjust Date =
VAR cur_date = [Date]
VAR _val =
    SWITCH (
        TRUE (),
        cur_date >= DATEVALUE ( "2023/01/01" )
            && cur_date <= DATEVALUE ( "2023/01/27" ), DATEVALUE ( "Jan 2023" ),
        cur_date >= DATEVALUE ( "2023/01/28" )
            && cur_date <= DATEVALUE ( "2023/02/24" ), DATEVALUE ( "Feb 2023" ),
        cur_date >= DATEVALUE ( "2023/02/25" )
            && cur_date <= DATEVALUE ( "2023/03/31" ), DATEVALUE ( "Mar 2023" )
    )
RETURN
    _val

    3. add a bar chart with fields

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.