Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Will you able to provide sample?
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
Also I have 4 expressions countering the each product types
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>'
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
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)
The expression for weekend formatting bold
i
f(match(weekday(Day_Month_Year),'Sat','Sun'),'<b>')
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'))