Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
HI , I have a question, I add tooltips on graph customer name , And the Tooltip include This Month and Last Month valume and Percentage Between TM and LM .
i used the DIFF calculation , to see the percentage between TM Vs. LM , I'd like to understand why when hover over the Customer name the DIFF Calculation shown 0.00% as you can. it should Show the Total Percentage from Jan to Aug of TM and LM , isn't it ?
Any idea ?
thanks
Solved! Go to Solution.
@Chanleakna123,
You can create measure using DAX below. Then put the measure to a card visual on the Tooltip page, I have sent your modified PBIX file via Private Message.
Measure = DIVIDE([Total Customers],CALCULATE(DISTINCTCOUNT('Daily Sale PC'[Customer Name - Store]),ALL('Daily Sale PC')))
Regards,
Lydia
@Chanleakna123,
You can create measure using DAX below. Then put the measure to a card visual on the Tooltip page, I have sent your modified PBIX file via Private Message.
Measure = DIVIDE([Total Customers],CALCULATE(DISTINCTCOUNT('Daily Sale PC'[Customer Name - Store]),ALL('Daily Sale PC')))
Regards,
Lydia
HI ,
thanks you , now i understand why it doesn't show the TM vs. LM in percentage in bar chart.
And above pictures , i have tooltips on first bar chart , 96 count of customers ,
we have total 103 Customers ,
so 96 customer should be 93% , so how can i turn this value to 93% ? I do manually on format field but it shown 100% , your support is much appreciated.
thanks you
Team , I have Daily Sale from Customer, and i view the report in Monthly, And in my tooltip ,i have created the Count of Customer who purchased the goods from us in Aug , As you can see the Tooltips show the number and this is Manual ,, but i want to convert this to Percentage % of Total Customer , it mean in Aug , how many % of grand total Customer who purchased the good from us ? I failed to do so . below are the tables.
Customer Name :
Customer | Name 1 |
100010020 | YOU LY |
100010040 | CHIN CHAN THO |
100010449 | SO ENGCHHIM |
100010564 | CHAV RAKSMEY |
Daily Sales :
Customer Name - Store host code | Customer Name - Store | Pack Type | Material Description host code | Material Description | 1/1/2018 |
0100010020 | YOU LY | CAN | 4223 | Coke 330ml 24 Sleek CAN SF | 0 |
0100010020 | YOU LY | CAN | 4686 | Samurai Strawberry 330ml 24 Sleek CAN | 0 |
0100010020 | YOU LY | PET | 1108 | Coke 1.5L 6 S/W NP | 0 |
0100010020 | YOU LY | PET | 1306 | Mutant Red 400ml 4X6 PET SF Strawberry | 0 |
0100010020 | YOU LY | PET | 1742 | Coke 390ml 4X6P PET SF | 0 |
0100010020 | YOU LY | PET | 2090 | Sprite 1.5L 6 S/W NP | 0 |
0100010020 | YOU LY | PET | 2597 | Mutant Gold 400ml 4X6 PET SF | 0 |
0100010020 | YOU LY | PET | 3089 | Fanta Orange 1.5L 6 S/W NP | 0 |
0100010020 | YOU LY | PET | 3497 | Fanta Fruit Punch 1.5L 6 S/W NP | 0 |
0100010020 | YOU LY | PET | 4894 | S. Strawberry 480ml 4X6 PET SF | 0 |
0100010020 | YOU LY | PET | 4915 | Samurai Fruity 480ml 4X6 PET SF | 0 |
0100010040 | CHIN CHAN THO | CAN | 1305 | Mutant Red 330ml 24 Sleek CAN Strawberry | 0 |
0100010040 | CHIN CHAN THO | CAN | 1906 | Fanta Fruit Punch 240ml 12 CAN TH | 0 |
@Chanleakna123,
The TY Vs. LM measure only returns correct value when you put the measure with MonthName field or Date field in a single visual.
In your scenario, you can drag MonthName field or Date field to your clusted bar chart. For more details, please check the PBIX file I sent to you via Private Message.
Also could you please describe the logic that you use to calculate Customer count out of the total customer? Please post expected result based on the sample data in PBIX file.
Regards,
Lydia
@Chanleakna123,
Does the percentage show correctly in the tooltip report page? Could you please share your PBIX file to me via Private Message? You can upload PBIX file to OneDrive and post shared link of the file via Private message.
Regards,
Lydia
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |