Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
99 | |
87 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |