Duplicate the row based on Slicer selection

[Anonymous]

I have a requirement to show the same row based on slicer selection.

when index is selected as TTF then automatically i need to see 2 rows of same columns as per below screenshot.

when index is selected as Matif then automatically i need to see 2 rows of same columns as per below screenshot.

may i know how to acheive this ? Please any suggestion will help

[Anonymous · Accepted solution]

Hi  @Anonymous ,

When each column of your data is the same, Power BI will automatically aggregate into one row in Visual, only one column will be displayed, you can add Index in Power Query, add a label to each row, and use the IF+Countx function to display 2 rows of the same data

Here are the steps you can follow：

1. In Power Query -- Add Column – Index Column – From 1.

2. Create measure.

Flag =
var _count=
CALCULATE(
    COUNT('Table'[Index]),
    ALLEXCEPT(
       'Table','Table'[Country],'Table'[Spend Category],'Table'[Index],'Table'[Last Value],'Table'[Assumption Scenario],'Table'[Correlation]))
return
IF(
    _count=2,1,0)

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly