Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
Im trying to recreate a chart previously built in Excel. My dataset is of three different products with three measures, two of which have the same scale. The first measure is the total number of health care providers and is the same for all products. The second measure is the number of prescribers of product 1,2,3. The third measure is the mean amount sold per prescriber. I would like to display the last measure as multiple color-coded lines, without having to create an individual measure for each product (as suggested in this solution. The image in that question can also be used as reference).
My current data structure is the following variables : 1) Product, 2) Number of HCPs, 3) Number of Prescribers, 4) Mean Amount/Prescriber
Thanks for the help!
Thanks for the help.
@Anonymous
There is already an idea, you may leave a comment and vote it up.
A correction:
The current data structure is as follows:
1) Product
2)AnalysisMeasure (encodes Quantity HCP, Quantity prescriber, Mean amount/prescriber)
3) Values
I have already created seperate measures for quantity HCP, quantity prescriber, etc.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |