Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to Show Bar Chat data in Text Box
Ex: In Bar chat year wise sales
if i click on year 2018 i want to show 2018 year total sales in text box
In bar chat Dimension : Year (2016,2017,2018)
and Expression : Sum (Sales)
if i click on 2016 display 2016 sales in text box
Create Textbox with 2 measures:
Measure 1: =getfieldselections(Year)
Measure 2: =sum(Sales)
iam using container it contains 3 bar chats
1. year wise sales
2. month wise sales
3. week wise sales
if i click on 1. year wise sales i need to display all years sales in text box and
click on one year in bar chat display selected year sales in text box
if i click on 1. month wise sales i need to display 12 month sales in text box and
click on one month in bar chat display selected month sales in text box
we can use two text boxes
Ah ok.
there's not stright forward way to identify which chart is selected in container. You need macros. see below
Another option is to move away from containers and use text objects (and variables) as selections to show / hide the Year, monthly, weekly chart. From a UX point of view this is better IMHO. then use the same variables to show the appropriate expression in your text object