Power BI

[Sean_S]

Usually, when we add a column to filter, PowerBI will automatically group that column data. Is it possible not to group the data on the filter and list/show all the duplicates? 

[jdbuchanan71]

Tabular Editor is not another site, it is a tool you download and use to modify your .pbix file.

[jdbuchanan71]

Unfortunately no.  The Keep Unique will always apply to the column so if you want to have it group on some reports you would need a groupable copy of the column where Keep Unique is set to false.

[Sean_S]

Thank you for your response! I don't think it's an option for me to use company data on other sites (tabular editor)

[jdbuchanan71]

It is not, no.  For that you would need to add a copy of the colmn to the same table and set only one of them to keep unique values.

[Sean_S]

Any other way around that we can use in PowerBI itself?

[jdbuchanan71]

You can, using Tabular Editor.  You need to identify your key column, then you can set your name column to keep unique values.

https://www.sqlbi.com/tools/tabular-editor/

Before setting 'Keep Unique Rows'

After setting  'Keep Unique Rows'

[Sean_S]

But it will affect other dashboards right? Is it possible to set it for only specific dashboards?