Forum Discussion

dawcza3's avatar
dawcza3
Frequent Visitor
8 years ago

Color Char Columns Based On Week Day Number

Is there any way to choose colors on all available types of week day ? Currently I'm showing data in date format (day) on chart. The thing that I trying to do is color my columns on diffrent color for Week Days and diffrent color for Weekend Days. Is there any way to do this with Power Bi ? Solution must work with direct query mode which I already using in my report.

2 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee

    dawcza3 wrote:

    Is there any way to choose colors on all available types of week day ? Currently I'm showing data in date format (day) on chart. The thing that I trying to do is color my columns on diffrent color for Week Days and diffrent color for Weekend Days. Is there any way to do this with Power Bi ? Solution must work with direct query mode which I already using in my report.


    dawcza3

    AFAIK, it is not supported. You can check those ideas and vote them up.

    By the way, what is the chart in your case, there may exist some workaround if you could post more details of your scenario.

  • dawcza3's avatar
    dawcza3
    Frequent Visitor

    This is what i want to achive in power bi. The yellow columns are the days which is in weekend and i want to color them on diffrent color than other days.