Specific Text Reference in PowerBI

[Hengqiiiiii]

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!

[v-frfei-msft · Accepted solution]

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

[Hengqiiiiii]

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