Forum Discussion

Settz's avatar
Settz
New Member
1 year ago
Solved

Bar Chart Filter and X Axis Column Selection

Hi   I have a report that is using a Bar Chart Visualiser to present quantities on Y Axis and Date on the X Axis.   The I need to be able to change the date used on the X Axis between Order Entry...
  • rajendraongole1's avatar
    1 year ago

    Hi Settz  -Create a Parameter Table

    eg: DateParam =
    DATATABLE(
    "Date Type", STRING,
    {
    {"Order Date"},
    {"Delivery Date"}
    }
    )

     

    Now, create a measure that dynamically filters the data based on the selected date type and only includes rows in the reporting window.

     

    ShowQty :=
    VAR SelectedDateType = SELECTEDVALUE(DateParam[Date Type])
    RETURN
    CALCULATE(
    SUM(Orders[Qty]),
    FILTER(
    Orders,
    (SelectedDateType = "Order Date" && Orders[In Entry Window] = 1) ||
    (SelectedDateType = "Delivery Date" && Orders[In Deliv Window] = 1)
    )
    )

     

    Create a calculated column or use a measure to switch the date used on the X-axis

    SelectedDate :=
    SWITCH(
    SELECTEDVALUE(DateParam[Date Type]),
    "Order Date", Orders[Order Date],
    "Delivery Date", Orders[Delivery Date]
    )

    you will need to create a disconnected calculated table or duplicate your date field and then filter it accordingly in your visual. Hope this works. please check