Create dynamic charts

Question

Hi all,&nbsp;I need to implement a dashboard that will present several bar charts based on the&nbsp;number of rows returned in my dataset. As illustration, my dataset is like below:Category &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KPI &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ValueCAT1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KPI A &nbsp; &nbsp; &nbsp; &nbsp;10CAT1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KPI B &nbsp; &nbsp; &nbsp; &nbsp; 5CAT2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KPI C &nbsp; &nbsp; &nbsp; &nbsp; 3CAT3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KPI D &nbsp; &nbsp; &nbsp; &nbsp; 8CAT3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KPI E &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1CAT3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KPI F &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10CAT3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KPI G &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9&nbsp;The slicer will contain the list of categories (CAT1, CAT2, CAT3). If the user selects the CAT1 on the slicer, then my dashboard needs to present 2&nbsp;diferent bar charts for KPI A and KPI B. If the user selects CAT3 then the dashboard will present 4 diferent bar charts.&nbsp;How to implement that? Do I need to create a custom visual? If so, is there any example to guide me?&nbsp;Thanks a lot,&nbsp;Guilherme Soares

eric_zhang · Answer

soaregj wrote:
Hi all,
&nbsp;
I need to implement a dashboard that will present several bar charts based on the&nbsp;number of rows returned in my dataset. As illustration, my dataset is like below:
Category &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KPI &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Value
CAT1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KPI A &nbsp; &nbsp; &nbsp; &nbsp;10
CAT1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KPI B &nbsp; &nbsp; &nbsp; &nbsp; 5
CAT2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KPI C &nbsp; &nbsp; &nbsp; &nbsp; 3
CAT3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KPI D &nbsp; &nbsp; &nbsp; &nbsp; 8
CAT3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KPI E &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1
CAT3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KPI F &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10
CAT3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KPI G &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9
&nbsp;
The slicer will contain the list of categories (CAT1, CAT2, CAT3). If the user selects the CAT1 on the slicer, then my dashboard needs to present 2&nbsp;diferent bar charts for KPI A and KPI B. If the user selects CAT3 then the dashboard will present 4 diferent bar charts.
&nbsp;
How to implement that? Do I need to create a custom visual? If so, is there any example to guide me?
&nbsp;
Thanks a lot,
&nbsp;
Guilherme Soares

soaregj
I don't think it is possible, even with custom visual. The slicer visual is for filtering data and it can't control other visuals shown/hidden.
As a workaround, instead of showing different bar charts, show the data in one chart setting the KPI as "Legend" field.

soaregj · Answer

Thanks&nbsp;Eric_Zhang. I was probably&nbsp;too simplistic in my example. Sorry for that.&nbsp;What I need is something like in the link below. Please notice every chart is a KPI and the quantity of KPI's (charts) varies from the location selected in the ChicletSlicer, meaning the charts are dynamically created on the report.&nbsp;https://drive.google.com/file/d/0B7MRYt91QJPATGd4VEEzeVpzMkE/view&nbsp;&nbsp;Thanks,&nbsp;Guilherme&nbsp;

Forum Discussion

Create dynamic charts

2 Replies

Related content

Dynamic Chart

Creating a Control Chart

Creating a dynamic slicer

Donut Chart - dynamic percentage

Dynamic Cards by Selection on a Chart