Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have a PBI table. If the table has duplicated rows I can't see them in this visual. When there are duplicated rows, I can only see one row instead of all. This causes problems when I use the count function. As an example let's take the tables below,
Real Data Table
Date | Incident |
05/19/23 | An accident happened due to a lack of attention |
05/19/23 | An accident happened due to a lack of attention |
05/19/23 | Slips and falls |
PBI Table Visual
Date | Incident |
05/19/23 | An accident happened due to a lack of attention |
05/19/23 | Slips and falls |
When I use the count function, it tells me there are 3 incidents. But if I visualize them using the PBI table and export the data, I can only see two incidents like the second table. I need to export the whole data set. Like I can see them in the "Data View" tab. Plz tell me how can I download the whole data set using the export function
You would need to have a column which uniquely identifies each row. If your dataset doesn't have one already then you could use Power Query to add an index column.
You would need to include this column in the table visual so that each row would be shown rather than combining duplicates, but you could set the width of the column to 0.
User | Count |
---|---|
64 | |
59 | |
47 | |
33 | |
32 |
User | Count |
---|---|
84 | |
75 | |
56 | |
50 | |
44 |