Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Relationship issue (Slicing is not working in Metrix with sales amount Day wise)

    Posted Aug 01, 2022 12:40 AM
    Hi All Good day..
    I have an issue when i pull the Weekday in Rows and Sales Amount in to Values filter context is not working. There is a valid Relationship between the tables.
    I would request to resolve the issue and correct me the mistake what i have done.

    I have attached the screen shots for reference.


    ------------------------------
    Ubedulla E
    Power BI Developer
    Bangalore
    ------------------------------


  • 2.  RE: Relationship issue (Slicing is not working in Metrix with sales amount Day wise)

    Gold Contributor
    Posted Aug 02, 2022 01:54 AM
    Hi,

    it seems the relationship does not match.

    Can you confirm that both fields (date and orderDate) have datatype date and that orderDate values available in the date table?

    I guess your measure is only a sum of a amount column?

    Best regards,
    Martin

    ------------------------------
    Martin Frisch
    BI Developer
    Trützschler GmbH & Co. KG
    ------------------------------



  • 3.  RE: Relationship issue (Slicing is not working in Metrix with sales amount Day wise)

    Posted Aug 02, 2022 02:36 AM
    Thank you soo much Martin Frisch..
    Yes, As you suggested the orderDate was in Text format.
    I converted it into Date format and now its been working fine.

    ------------------------------
    Ubedulla E
    Power BI Developer
    Bangalore
    ------------------------------