Dashboard with previous year values not displaying in a table

[mtram]

I have dashboard where I have a year dropdown from a Date table.

Table 1 - I want to display customer count for current year based on the dropdown selection by each team where Team is rows, Month-Year (MMM-YY) as columns from the Date table, and customer count as values.

Table 2 - I want another table to show the previous year based on the dropdown selection in the same layout. I have a column in Date Table for the previous Year info.

The issues I am facing is when the drop down is selected for 2025 which is the current year. the current table showing all customer from Jan through June since July data is not available yet. Current date is 7/23/2025.

While on the previous year table, the customer count is showing for all team through June only, no count is showing for July through December for the team row however, the total line is showing the actual total.
Why is it not showing the count by team for the previous year? My guess is because the current year is empty which cause the previous year table to be empty for the team, but the total is showing. which makes me think it recognizes the values not nothing displays on the table.

Note: when 2024 is selected from the dropdown, all the months values are showing on the table for both, the first and second table.

Thanks in advance for any advice to get this to work!!

[v-agajavelly]

Hi @mtram ,

Did you get a chance to try the disconnected slicer approach with the helper columns (Show_PY) and the measures using All(Date)? That should force the full Jan–Dec view for the previous year while keeping the current year dynamic. Happy to hear if that solved the issue on your side.

Regards,
Akhil.

[v-agajavelly]

Hi @mtram ,


Use a disconnected slicer and create measures that ignore the date table filter using ALL('Date'). Add helper columns like Show_PY to force previous year to display full Jan–Dec. This fixes the issue cleanly.

Regards,
Akhil.

[v-csrikanth]

Hi @mtram 
Welcome to Fabric Community.
As per my understanding your requirement, the issue was caused by the shared Date table filtering both visuals. Since current year only has data up to June, it indirectly hides July–Dec in the previous year matrix. 

• To fix it, create a disconnected Year slicer.

  Year Slicer = DISTINCT('Date'[Year])

•  Create two measures using All('Date') to ignore unwanted filters.

  Current Year 
  Customer Count CY = 
  CALCULATE(SUM(CustomerCounts[CustomerCount]),
  FILTER(ALL('Date'), 'Date'[Year] = SELECTEDVALUE('Year Slicer'[Year])))
  
  Previous Year 
  Customer Count PY = 
  CALCULATE(SUM(CustomerCounts[CustomerCount]),
  FILTER(ALL('Date'), 'Date'[Year] = SELECTEDVALUE('Year Slicer'[Year]) - 1))
  
  

• In the matrix visuals, use Date[MonthYear] as columns, Team as rows, and apply visual filters:

  CY: Date[Year] = SELECTEDVALUE('Year Slicer'[Year])

  PY: Date[Year] = SELECTEDVALUE('Year Slicer'[Year]) - 1

• Optional: To hide future months in current year matrix.

  IsPastOrCurrentMonth = IF('Date'[Date] <= TODAY(), TRUE, FALSE)

Add IsPastOrCurrentMonth = TRUE as a visual filter.

Now the current year matrix shows only Jan–Jun, and the previous year matrix shows full Jan–Dec.

Best Regards,
Cheri Srikanth
CST_Community Engineer.

[mtram]

Thanks for the response.  I followed your recommendation but when it comes to add the below to the Filter Pane, i do not see a place to let me enter the DAX filter for the Year-Month for the table.  is there another way to get this to filer by the dropdown?

• In the matrix visuals, use Date[MonthYear] as columns, Team as rows, and apply visual filters:

  CY: Date[Year] = SELECTEDVALUE('Year Slicer'[Year])

  PY: Date[Year] = SELECTEDVALUE('Year Slicer'[Year]) - 1

[speedramps]

I want to help you but your description is too vague. Please write it again.

You are confussing the issue explain what you have done wrong, rather than explain what you want to do right.
Also please provide exampkle input data as a table and not a picture.

I am am happy to help with Power Bi and DAX but not waste time copy typing data thank you. 😀😀😀

You will get a quicker and better response without misunderstandings if you put time and effort into carefully writing a clear problem description with example input and output data. Look forward to helping you when this information is forthcoming

* Please DON'T copy & paste your DAX that does not work and expect us to fathom what you want. (That is just crazy). ‌‌
* Please DO give a simple non-technical functional description of what you want
* Keep it simple and break large projects into smaller questions and ask just one question per ticket.
* Rename columns to user friendly names. Avoid your own system jargon that we may not understand.
* Most importantly please provide example input data as table text (not a screen print) so helpers can import the data to build a solution for you. (Learn how to share data below)
* Provide the example desired output, with a clear step-by-step description of calculations and the process flow.
* Take time and care to use the same table and field names in the input, output and description so we can understand your problem and help you.
* Remove any unneeded tables, rows or columns which may cause confusion. Keep it short and concise with the minimal information regarding the key problem.
* Remember not to share private data ... we don't want you to get into trouble. ‌‌
* Please click the thumbs up button for these helpful hints and tips. Thank you.

Learn how to attach data in the forum using OneDrive:-
* Save your file in a OneDrive folder
* Right click on the file and click the “Share” blue cloud icon
* Click the bottom “Copy” button
* Click” Anyone with link can edit”
* Click “Can Edit”
* Click “Can View”
* Click “Apply” button
* Click “Copy”
* Paste the generated link via the forum, email, chat, or any other method.
* Helpers can then download your data, build a solution and share it back.

Learn how to attach data in the forum using Dropbox:-
1. Open Dropbox: Access the Dropbox folder on your computer or through the Dropbox web interface.
2. Select File/Folder: Find the file or folder you want to share.
3. Click Share (or Get Link): Look for a "Share" option or a similar "Get Link" option.
4. Choose Permissions: Decide whether to allow "view only" or "view and download" access.
5. Copy and Share: Copy the generated link and share it with anyone via the forum, email, chat, or any other method.