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 9 days ago
    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 8 days ago
    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 8 days ago
    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
    ------------------------------