Forum Discussion
Post Prodigy!!Need Help , Tooltips On TM Vs. TM shown 0.00%
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
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
7 Replies
@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,
LydiaChanleakna123,
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
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
- Chanleakna123
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,
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
Anonymous you're awesome.
thanks you
