Forum Discussion

Buster's avatar
Buster
Frequent Visitor
6 years ago

Merging Data from two Columns but Maintaining All Row Information

I wish to create visuals using data from sample table below but view across time by ID (column A) whilst retaining all unique values. Problem is ID ofetn repeats and BI combines values each time it s...
Need Help
mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Buster ,

 

Power BI shows the data in two ways ...
1. as aggregable value. (e.g. SUM)
2. as category (distinct)
... that's how it is at design.

 

If you want to see each entry \ value, something must be displayed that differentiates the values.