How to get filter values applied to a label displayed in Report

[modi123p]

Hi,

Customer might issue a a query such as "Customers by Revenue for Textile industry in Europe" from Cortana.

Here, the report applies appropriate filters for region, country and industry and it works fine.

But I would like the title within the report to change dynamically based on the filters applied.

It is necessary to display Industry: "Textile", Region: "Europe" 

Is there a way I can get this information displayed in a label inside Power BI?

[v-shex-msft · Accepted solution]

Hi @modi123p,

Based on my understanding, you want to get the Q&A filter result, right?

If it is a case, I think it is impossible, you can simple get the select item which choose in slicer, but you can’t get the Q&A result.(only can pin the result to dashboard)

Below is a sample about use slicer to get dynamically result tile. (get the value in slicer and drag them to card visuals as label):

Slicer:

 

Measures:

Selected Industry = "Industry: "& LEFT(CONCATENATEX(ALLSELECTED(Sheet1),[Industry]&","),LEN(CONCATENATEX(ALLSELECTED(Sheet1),[Industry]&","))-1)

Selected Region = "Region: "& LEFT(CONCATENATEX(ALLSELECTED(Sheet1),[Region]&","),LEN(CONCATENATEX(ALLSELECTED(Sheet1),[Region]&","))-1)

Result:

Regards,
Xiaoxin Sheng

[modi123p]

Thanks Xiaoxin Sheng