The user selects the calendar days and is directed not to cross fiscal years. This then filters the FiscalDayofYear slicer - This is the slicer that drives what Top Units sold for user selected Fiscal Year. I'm not showing this in the photo.
What I'm trying to do is create a card that displays the FiscalDayOfYear slicer values, as this slicer is hidden from the user so that they don't use this for selection. Our users are more comfortable with the calendar days vs. knowing what day it is in the fiscal year.
I've found the postings for the displaying in a card the date slicer and that code works great. I can't get the same code to work for the FiscalDayOfYear slicer since Max and Min pulls the 1 and 364 respectively regardless of what the slicer shows. I've tried selected value with no luck as well.
Any help would be appreciated. Or is there a way to make a slicer just "display only"?
I am very new at learning Power Bi so, not sure would this work for your case but wanted to help you out and here is a suggestion:
Create a custom column in your calendar and name it let's say "isFiltered" and create a function with conditionals which compares the selected values with the range that "FiscalDayOfYear" has and returns 1 if it is in desired range and 0 otherwise.
Then use this column as visual filter and select "advance filtering > is" and enter 1 into the textbox.
I'm super new as well and do a little better if you can help walkthrough the code that you are using in the "isFiltered" column. And is this to address that I don't want the user to cross fiscal years?
I'm not sure how this helps me with my display card that shows the FiscalDayOfYear values that are driven from the calendaryear entry.
If I don't get you wrong you are trying to show a specific range of values has chosen by the slicer, you only see values from 1 to 364 but not the values you desired from FiscalDayOfYear. So, I was thinking to create a filter which filters out the numbers between 1 and MIN(FiscalDayOfYear) plus MAX(FiscalDayOfYear) and 364. So you will get only the desired range of numbers and user does not need to cross fiscal day slicer.
Correct me if I am wrong please. I would createa snippet if this is the scenario.