Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |