Bar Chart to be displayed Based on One Value of Expression
I have to display a bar chart based only on One Value of an Expression. The requirement is to display a bar chart initially with One Value of an Expression.
Example: I have a dimension (Month) and Expression (Leave Types). Month contains multiple values in different leave types. Leaves Types are Annual, Sick, Half Day, Business Travel, Examination etc. So data is something like this.
Month Leave Type
Feb Business Travel
The requirement is to display a Bar chart containing Month on X-Axis and Count of Leave Type on Y-Axis. At the start of dashboard, only Annual Leaves details should be shown only in this Bar Chart. I cannot set the overall value in Leave Type as Annual as it will make other objects to be fixed initially on Leave Type - Annual. I added another Calculated Dimension as Annual but it is not effecting the X-Axis. The X-Axis coming with the counts of all Leave Types.
Picture 1 (Leave_Type_Annual) shows two objects. The second object (Leave Type Monthly Trend) should be based on selection of value in first object (Emp. By Leave Types - 2018). But, at the start of dashboard, all values should come on first object and second object should be displayed only with Annual Leave Type data.
Picture 2 (Leave_Type_Annual_2) shows the values which has to be appear initially in second object.
If anybody can help me out and let me know how to initially fix the Bar-Chart with only Annual Leave Type value.