Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
112 | |
96 | |
94 | |
64 | |
58 |