In most cases it's a nice feature that duplicates are automatically removed, but in some cases you also need the duplicates.
See for example Solved: Re: Table Visual: Prevent Automatic Removal of Dup... - Microsoft Fabric Community
For now we use a workaround by adding an index to the table, set the name to an empty character and make it so small users won't notice it's there.
Steps for the hidden column:
- Rename it using a whitespace character;
- Go to "Specific column" and make the font and backgroundcolor white;
- Go to "Values" and disable "Text wrap";
- Make the column as small as possible.
No CommentsBe the first to comment
Recent ideas
Fabric Copy Jobs desperately need basic editability after creation.
Requiring users to recreate an entire Copy Job just to change something as fundamental as the source connection or connection URL is unnecessarily restrictive and creates significant maintenance over...mpersha10 hours agoRegular VisitorNew3Views0likes0CommentsPreserve Background Colors When Exporting Power BI to Excel
When exporting a Power BI table or matrix to Excel, the data is exported correctly, but background colors and conditional formatting used to distinguish records are not preserved. It would be helpful...surya312 hours agoNew MemberNew5Views0likes0CommentsAdd an option to hide all visual-level filters
As a best practice, we often need to hide fields and measures from the Filters pane in Power BI reports. When a visual contains dozens of fields and measures, manually hiding each one individually ca...Roman202612 hours agoNew MemberNew21Views0likes2CommentsPower BI Table visual – "Show items with no data" causes blank values
A table visual groups only on columns (no measures) from a parent table and its child table, with "Show items with no data" on. For parent rows that have no child rows, the parent row appears, but an...ratcowboy14 hours agoNew MemberNew16Views1like0Comments