Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello
My data is:
Product ID - Sales - Date - Type of Sales
A - 5 - 01/01/20 - Retail
A - 4 - 01/02/20 - Web
C - 3 - 02/01/20 - Retail
etc
Where do I put each of these columns in a line graph so that I will show in the Sales per Date for each Product/Type of Sales pair?
The Legend field does not seem to be able to accept more than one columns.
Thanks!
Solved! Go to Solution.
You can concatenate the ID and Type as a new calculated column and then put that column in the legend.
Product-Type = Sales[ProductID] & "-" & Sales[Type Of Sales]
Here's what that might look like using a modified version of the .pbix @rodrigosan provided (concatenated two different ways):
You could also consider using small multiples to get one of these options (no new column required):
You can concatenate the ID and Type as a new calculated column and then put that column in the legend.
Product-Type = Sales[ProductID] & "-" & Sales[Type Of Sales]
Here's what that might look like using a modified version of the .pbix @rodrigosan provided (concatenated two different ways):
You could also consider using small multiples to get one of these options (no new column required):
Hi, could you check if the solution suits you
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |