Hello Matt,
Chapter 15, Dax Topic: Time Intelligence, Calculating Sales Year to Date, page 117 of the book shows a screenshot where you show the Visual Filter for the CalendarYear being applied for the year 2003. I cannot reproduce this. When I drag the CalendarYear field into the Visual Filters, it goes to the bottom after MonthName(All) and Total Sales as shown below:
MonthName(All)
TotalSales(All)
CalendarYear
This is NOT how your screenshot shows it. In your book's screenshot, the CalendarYear is ABOVE the MonthName(All) and TotalSales(All) fields. I cannot drag the CalendarYear and position it above the two fields.
Consequently, the numbers don't match when I filter on the year 2003.
I don't understand it. Please help.
Thanks.
Bharat
Visual Filters Page 117 of the book
-
MattAllington
- Posts: 1154
- Joined: Sun May 04, 2014 4:01 pm
- Location: Sydney, Australia
Re: Visual Filters Page 117 of the book
Sorry I missed this. Can you share your workbook here?
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training
Power BI Training
Return to “Help with the Book "Supercharge Power BI"”
Who is online
Users browsing this forum: No registered users and 0 guests


