Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to 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
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
Thanks Xiaoxin Sheng
User | Count |
---|---|
83 | |
77 | |
71 | |
70 | |
54 |
User | Count |
---|---|
107 | |
99 | |
88 | |
79 | |
67 |