Search code examples
powerbipowerbi-datasource

How to show value in only first cell in case of duplicate Power BI

I wrote a query in Power BI which returns results like this

enter image description here

Is it possible: For the first column Service Name if value is same in cells than to show value in the first cell and than leaves all the other cells blank until the value is changed, If the new value is repeating than again leave all the cells blank until a new value found

Solution

  • All you need to do is to change the table visualization to matrix visualization.

    Just keep the column under the Rows section.

    rows

    The matrix visualization will then group and hide the repeating values automatically.

    result