Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Chanleakna123
Post Prodigy
Post Prodigy

!!Need Help , Tooltips On TM Vs. TM shown 0.00%

1.gif

 

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 

1 ACCEPTED SOLUTION
v-yuezhe-msft
Employee
Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
Chanleakna123
Post Prodigy
Post Prodigy

@v-yuezhe-msft you're awesome. 

 

thanks you 

v-yuezhe-msft
Employee
Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Chanleakna123
Post Prodigy
Post Prodigy

1.PNG1.gif

 

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 

1.gif

 

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 : 

CustomerName 1
100010020YOU LY
100010040CHIN CHAN THO
100010449SO ENGCHHIM
100010564CHAV RAKSMEY

 

Daily Sales : 

 

Customer Name - Store host codeCustomer Name - StorePack TypeMaterial Description host codeMaterial Description1/1/2018
0100010020YOU LYCAN4223              Coke 330ml 24 Sleek CAN SF0
0100010020YOU LYCAN4686              Samurai Strawberry 330ml 24 Sleek CAN0
0100010020YOU LYPET1108              Coke 1.5L 6 S/W NP0
0100010020YOU LYPET1306              Mutant Red 400ml 4X6 PET SF Strawberry0
0100010020YOU LYPET1742              Coke 390ml 4X6P PET SF0
0100010020YOU LYPET2090              Sprite 1.5L 6 S/W NP0
0100010020YOU LYPET2597              Mutant Gold 400ml 4X6 PET SF0
0100010020YOU LYPET3089              Fanta Orange 1.5L 6 S/W NP0
0100010020YOU LYPET3497              Fanta Fruit Punch 1.5L 6 S/W NP0
0100010020YOU LYPET4894              S. Strawberry 480ml 4X6  PET SF0
0100010020YOU LYPET4915              Samurai Fruity 480ml 4X6  PET SF0
0100010040CHIN CHAN THOCAN1305              Mutant Red 330ml 24 Sleek CAN Strawberry0
0100010040CHIN CHAN THOCAN1906              Fanta Fruit Punch 240ml 12 CAN TH0
v-yuezhe-msft
Employee
Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yuezhe-msft
Employee
Employee

 
Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yuezhe-msft
Employee
Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.