Bar chart Drill down - Change X Axis to BOLD conditionally

[Anonymous]

Hi,

I have  requirement of changing the font to BOLD in a drill down on a Bar chart

Drill down columns  used in the below chart as follows

Calender Drill

   Month_Year

   Week

   Date

I need to BOLD the weekend dates when it's drill to the date level

below image

I have bold the numbers in the chart but ideally like to have the 24th and 25th in BOLD

Thanks!

Paul

[Anil_Babu_Samineni]

Will you able to provide sample?

[Anonymous]

Hi Anil

The data is very sensitive. Therefore I can't provide a sample

I can explain what I have done

I have 2 dimensions

Frist one Drill as I have indicated  

Calender Drill

   Month_Year

   Week

   Date

Second one

Grouped indicator

This is the get the stacked Bar chart grouped 

I will have 2 products grouped in one stacked in one Bar  and rest of the products grouped in the another bar stacked

Drill will be Month_Year view first appearance then drill to Week and then to date

I need the date to be highlighted when it's weekends. This is a column Calender drill (Date)

Let me know if you need further details

Thanks!

Paul

[Anonymous]

Also I have 4 expressions countering the each product types

[Anil_Babu_Samineni]

Explanation was good, What i am thinking is with out application bit difficult to debug

Some how, Please consider it as Text color like below

=If(GetCurrectField("Group Name") = 'Date' and Date = '2017-06-21', Green())

If you want to show text bold you can use something like below

='<B>'

[Anonymous]

Where do you wanted me to have the condition? In the dimensions?

Note - Bar chart will not apply any formatting at the dimension level. Your suggestion will work with Private not work with Bar Charts 

[Anonymous]

[Anonymous]

the above was resolved with below article however I get the date duplicated in X axis

Changing Dimension Colour and Font in Bar chart (Selectively)

[Anonymous]

The expression for weekend formatting bold

i

f(match(weekday(Day_Month_Year),'Sat','Sun'),'<b>')

[Anonymous]

I have resolved the duplication issue as well.

It's due to the fact I have developed a Bar Chart Grouped

in the expression where you need to add condition generate the label for one of the group items

if(JBADMISSION.DIM_GROUP=2,Date(Floor(Day_Month_Year),'DD-MM-YYYY'))