Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi i have a card visual and a matrix visual, along with that i have a date slicer (between).
scenario: when the date slicer changes the value in the card and well as matrix gets adjusted to the last date in the date slicer.
matrix has categories(category column) as a row. Card visual is showing the over all values without the category.
problem: for few dates, there are few category missing. When i slelect those dates , card visual does blank, but matrix visual shows value for which the category is present for that day and blank for the category which is not present for the day, shown below.
Card visual should show values of 3 of the above category but it just showing blank.
Below is the calculation measure for card visual:
please give me a solution
Sorry, would not be able to share the file. Its restricted
Hi @Mrignalini ,
Understand that you are not allowed to share the file, but is it possible to provide the relevant test data and describe it so that I can answer it for you as soon as possible.
Best regards,
Adamk Kong
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
9 | |
6 |