Forum Discussion
Date measure
Microsoft EmployeeHi Anonymous,
Could you please post me the data stracture in your row table, due to I could not figure out the data in your [Jun 2018 Hours Worked], [May 2018 Remaining Hours], [Jun. 2018 Remaining Hours] and [End Date] columns? And the dax formula you want to get is a measure or a calculated column?
Regards,
Danile He
I just found out that I cannot vary the tint of a color bar in the clustered column chart unless all bars are the same color and there is only one value in the Value field. I used different colors in the bars so the months would be different colors and stand out. Each remaining hours worked column is a separate value in the Values field so there are 12 values in the Values field. Using 12 values and multi-color bars eliminates my ability to fade the colors in the bars in which the contract has ended.
Now I need to determine if showing months in which the contract has ended by fading the bar is more important than the multi-colored bars. I don't know if the fading bar is doable at this point unless I use a totally different approach to this problem. Any suggestions would be appreciated.
I used the columns named Sep Remaining Hours, Oct Remaining Hours, Nov Remaining Hours as the Value field.
This is the table I have:
Thank you in advance for any ideas.