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

Prevent same data from showing multiple times on different rows on a Matrix Table?

  • 1.  Prevent same data from showing multiple times on different rows on a Matrix Table?

    Posted 14 days ago
    Hi All,

    I'm trying to recreate a real estate rent roll in Power BI, and have hit a wall. Within excel, it would work as a pivot table, but the matrix does not want to act the same way. Most of my data in the matrix is in rows, with only Future Rent Increases shown as a value. This is fine for most tenants, but some will have multiple rent categories tied to the same suite, which show up on the following row. However, PowerBI associates the Future Rent Increases with each row. Is there a way to show the values on the first instance of the tenant name, or tie it to some other unique tenant characteristic?

    Alternatively, I'm open to changing to a table if there is a way to remove duplicative data on subsequent rows.

    ------------------------------
    Scott Davis
    Operations
    ------------------------------


  • 2.  RE: Prevent same data from showing multiple times on different rows on a Matrix Table?

    Posted 10 days ago
    Hi Scott,

    Please share Data Model (Tables, fields and relationship) , if you could share a sample file will be better.

    Thanks,

    ------------------------------
    Feras Alramli
    Mississauga ON
    ------------------------------



  • 3.  RE: Prevent same data from showing multiple times on different rows on a Matrix Table?

    Posted 10 days ago
      |   view attached
    Hi Feras,

    Thank you for taking a look. I've created a sample PBI dashboard with the issue I'm having. I've included a screen shot highlighting the data I want to remove or hide as well.



    ------------------------------
    Scott Davis
    Operations
    ------------------------------

    Attachment(s)

    pbix
    Rent Roll Example.pbix   170 KB 1 version


  • 4.  RE: Prevent same data from showing multiple times on different rows on a Matrix Table?

    Posted 9 days ago
    Hi Scott,

    Thanks for sharing PBIX file, In my view the most difficult part in power BI is transformation. How to shape the data to generate the report you need it.
    for this reason I done many changes to your file.

    Summery of changes & Recommendation:
    - Create below dimension
         - Tenants
        - Rental units
        - initial Contract
       - Date
    create fact table
        - contract changes

    Most of transformation done in Power Query , please review each step in contract changes.

    Thanks,
    Feras


    ------------------------------
    Feras Alramli
    Mississauga ON
    ------------------------------

    Attachment(s)

    xlsx
    rent roll data.xlsx   11 KB 1 version
    pbix
    Rent Roll Example-Feras.pbix   161 KB 1 version


  • 5.  RE: Prevent same data from showing multiple times on different rows on a Matrix Table?

    Posted 6 days ago
    Thank you Feras!

    Changing the way the data is presented looks to be the way to go. I really appreciate you taking the time and taking a look!

    ------------------------------
    Scott Davis
    Operations
    ------------------------------