Filter text from the excel and display it in dashboard

[dinesharivalaga]

Hi All ,

I want to create a measure to display a Average percentage of Automated and Manual invoices .

Below is the source :

June month automated % is 42.5% , same like Manual is 57.5%

I want to create a linear chart with both automated and manual lines in a single graph .

Currently i am using a two different graphs for auto and manual with activty type filters from filter panel .

Hope you understand my scenario .. please help on this ..

BR

DK

[v-shex-msft · Accepted solution]

HI @dinesharivalaga,

Perhaps you can try to union two table record and add a custom tag column to remark the source table. Then you can use date as axis, then tag field as legend and value field as value to create a line chart with two categories.

Regards,

Xiaoxin Sheng