Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a table visual which contains total 5 columns in which first column is for month and remaining is for 4 weeks and included 12 rows except header,
1st column = contains month and other columns contains 1st-4th week
Now I need to add tooltip for each of the cell in the table to show sale count for individual cell ,
I have followed the custom tooltip process , everything went fine
but count for individuals showing wrong count
January || 1week|| 2week||3week||4week
I have created measure but it showing total count of month thorughout each row
Please help me on this issue , Thank you all
@DHPBI2024 Try to create a measure like this if it works for you:
SaleCountMeasure =
CALCULATE (
SUM ( TableName[SalesColumn] ),
TableName[Month],
VALUES ( TableName[WeekColumn] )
)
If you find this insightful, please provide a Kudo and accept this as a solution.
Thanks for the quick response , Actually I need individual count of the values for each count ,
unfortunately you measure isn't working.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |