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

Change name column

  • 1.  Change name column

    Bronze Contributor
    Posted 5 days ago
    Hello,

    I made a report where the total costs are aggregated by 'RAPPORTAGE_EENHEID' and type of costs (column 8000, 8010 and 8015). However the first column are values who are not matched to any of the cost types (not 8000, not 8010 etc.).

    Is it possible to change the title of the first column to 'Others'

    thanks

    Mario



    ------------------------------
    Mario Sales
    Senior administrateur
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Change name column

    Posted 5 days ago
    Edited by Shane Cosgrove 5 days ago

    You could Transform the data and change the blank values to "Others"

    1. click Transform Data

    2.Right click on the column

    3.Select Replace Values

    4.value to find = null

    4.Replace with= Others

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Change name column

    Bronze Contributor
    Posted 4 days ago
    Hi Shane,

    Thanks for your reply, unfortunatly that will not do the job. I try to explain:

    the 'type of cost' is in a different table then the transaction values. The values table is connected to the 'cost type table' by projectnumber. The rows in the values table contain always a projectnumber. But, not all projectnumbers are in 'the cost type table'.

    So, every time when the project in the value table does not exist in the type of cost table the type of cost is empty.

    ------------------------------
    Mario Sales
    Senior administrateur
    ------------------------------

    Academy - Online Interactive Learning from Experts