Forum Discussion
Specific Text Reference in PowerBI
Hi, currently I am struggling with text reference in PowerBI. I would like to create a card function in PowerBI, which shows the text in a specific cell from excel database. The text in the cell will change if I modify some parameters in the excel database, and I would like to make PowerBI also change the text in card function. For example, I would like to create the card in PowerBI shows the text in E3 cell, could anyone teach me how to achieve this function? Thanks a lot!
Hi Hengqiiiiii,
I made one sample for your reference. Here we need to add an index column in excel or power query. Then you can use the measure as below to achieve your goal.
Measure = CALCULATE(MAX(Table1[E]),FILTER(Table1,Table1[index]=3))
For more details, please check the pbix as attached.
Regards,
Frank
2 Replies
Hi Hengqiiiiii,
I made one sample for your reference. Here we need to add an index column in excel or power query. Then you can use the measure as below to achieve your goal.
Measure = CALCULATE(MAX(Table1[E]),FILTER(Table1,Table1[index]=3))
For more details, please check the pbix as attached.
Regards,
Frank
Hi Frank, thank you so much for your kind help! It is really useful and I am so grateful that you take time to help me solve the problem!
Best wishes,
Hengqi
