Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Hi @Anonymous ,
I understand now. There is no easy way to accomplish this with a line chart. It will require a lot of work with DAX expressions. However, you can easily display the data in a line and cluster column chart. I have attached a screenshot of how I created a line and cluster column chart with your example report.
Hello @Anonymous ,
If I understand your requirements properly, you shouldn't have to create a new measure for each product. Instead use the field 'amount' as the value field for the line chart and keep the status slicer.
I hope this helps.
Hi Expert
Placing the field Amount into the Value... Does not give me a line for total and for each individual product... i need to show three / four or evern lines on the graph at any given time..the total also has to have its own line...
Hi @Anonymous ,
I understand now. There is no easy way to accomplish this with a line chart. It will require a lot of work with DAX expressions. However, you can easily display the data in a line and cluster column chart. I have attached a screenshot of how I created a line and cluster column chart with your example report.
Hi Expert
I can do the solution you have, whats the leg work using DAX to get the desired results.
The DAX work would depend on where the data stored and if the data is static (i.e., not changing over time) or dynamic (i.e., would be updated weekly/monthly/etc.).
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |