Thank you, Harsh, for sharing this with me.
I don’t know if I am not understanding or not, but what I am trying to figure out as to how to apply my situation to this one. On the airline situation, there is a claim status for each transaction in a table–as shown in the claim status table. Therefore, the measure that compares the claim status ID to the color will work.
In my situation, “Current Calendar Year” and Previous Calendar Year" are not in a table–they are only present in a measure–
in the date table–there are years, 2021, 2020, 2019, etc.–they are not labeled “Current Year” and “Previous Year” except through a measure.
So, how do I take the “Current Calendar Year” and assign a field value to it?
I made the table that is pictured above–however, it isn’t connected to anything.
Maybe I am missing something, but I am not seeing how this will work in my situation.
What I did do, however, was take the scenario that you gave me and made a few additional measures.
Current Calendar Year = SELECTEDVALUE(dDate[CalYear])
Current Year Icon = " • "
Current Fiscal Year and Icon = [Current Fiscal Year]& [Current Year Icon]
Previous Calendar Year = SELECTEDVALUE(dDate[CalYear]) -1
prev Year Icon = " • "
PY CalIcon = [Previous Calendar Year]& [prev Year Icon]
I then put the items into a table, made the headings to be a font color of white so that they would not show, and put it above the table–I formatted each column to be the same color as the bar chart for the individual year indicated. I then removed the legend from the chart.
I would have to do this for each chart–so I would rather get the idea that you have above working. I just am not sure how to do it. Let me know if I am missing something. Thank you!