Show graph corresponding to the list item choosen

[hamzahad91]

I have a list of items , every item have his graph in a different page, I would show the graph according to the item choosen . How is it possible to make ?

[anupampandey]

Hi,

Could you share some sample data please?

Thanks,

Anupam

[hamzahad91]

Here are the values

Here I have a slicer containing the 2 tables name. I woud that when I select Table1 it shows me the according graph ( in table1 page ) and samething when I click on table2

[v-caliao-msft · Accepted solution]

@hamzahad91,

How many items in your list? If you have only few items, this can be down by a measure. Please refer to the link below to see the details.

1. Merge tables.
   Edit table>Merge Queries
   
2. Rename your colums' name
   T1Quantity,T1Objectif, T2Quantity, T2Objectif.....
3. Create a slicer table
   
4. Create two measure in your table.
   c=
   var selectitem = MIN(SlicerTable[Table])
   return if(selectitem="Table1",SUM(Table1[T1Objectif]),SUM(Table1[T2Objectif]))
   SelectedQuantity =
   var selectitem = MIN(SlicerTable[Table])
   return if(selectitem="Table1",SUM(Table1[T1Quanitity]),SUM(Table1[T2Quantity]))
5. Create a visual, use SelectedQuantity in column, and use SelectedQuantity in line.

Result.

Regards,

Charlie Liao

[hamzahad91]

Thank you @v-caliao-msft , I have 10 visual to make (Is your exemple still working ?

I have some questions :

Why table 2 columns are copied in table1 ? should I Keep Table 2 ?

Can you explain me the 2 lines of code ?

[v-caliao-msft]

@hamzahad91,

I have 10 visual to make (Is your exemple still working ?
Yes, you need to merge those columns from different tables into one table.

Why table 2 columns are copied in table1 ? should I Keep Table 2 ?

In order to create the maesures conveniently.

Can you explain me the 2 lines of code ?

Which code do you need?

Regards,

Charlie Liao

[hamzahad91]

The measures .

And now that I have to add 10 items , how can I change the measures so it fits the new entities ?