Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Show 15 days dates gaps in Chart (Axis Option)

  • 1.  Show 15 days dates gaps in Chart (Axis Option)

    Bronze Contributor
    Posted 26 days ago
      |   view attached
    Hi There,

    I've attached a sample excel file for your reference. Similar output I would like to have in Power BI Dashboard.

    What I usually do everyday is, I add a new row in A2, to update last day's price.

    And than I go to chart and select the Horizontal Axis to edit the dates in Axis Option.

    For e.g. Today I changed the date to 10/26/2020 in Minimum (see below) and In Maximum I've added the date of the last day of this week. So my chart shows yesterday's date i.e. 21 Sep 2021

    Similarly, tomorrow, I'll only change the date to 10/27/2020 in Minimum.


    Apologize, if I've not clearly mentioned my requirement.

    But my requirement is to show the chart with 15 days gap dates.

    Thanking you in advance.

    Regards,
    Prem

    ------------------------------
    Prem Guru
    ------------------------------

    Attachment(s)

    xlsx
    15 Days Period.xlsx   27 KB 1 version


  • 2.  RE: Show 15 days dates gaps in Chart (Axis Option)

    Posted 25 days ago
    Edited by Rick Gosden 25 days ago
    Simplest way would be to add a filter flag to your date table.
    Add a calculated column:
    Flag = IF('Date'[Date]>(TODAY()-15),1,0)

    Then use the flag to filter the visual. Use "BASIC" filtering to only show rows where the Flag=1

    Use MAX('Your table'[Date]) instead of TODAY() if you want to always show 15 records, not just records for the last 15 days.



    ------------------------------
    Rick Gosden
    Systems Analyst
    [
    ------------------------------



  • 3.  RE: Show 15 days dates gaps in Chart (Axis Option)

    Bronze Contributor
    Posted 25 days ago
      |   view attached
    Hello Rick,

    Not sure if I've applied the calculated column correctly.

    I'm not getting the desired output as below graph/table:


    If we look in the X axis, there are dates which shows 15 days gap.

    I'm attaching PBI report for your reference.

    Thanks

    ------------------------------
    Prem Guru
    ------------------------------

    Attachment(s)

    pbix
    15 Days Period.pbix   48 KB 1 version