cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hengqiiiiii Frequent Visitor
Frequent Visitor

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!powerbi.png

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Specific Text Reference in PowerBI

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))

Capture.PNG

For more details, please check the pbix as attached.

 

Regards,

Frank

 

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Specific Text Reference in PowerBI

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))

Capture.PNG

For more details, please check the pbix as attached.

 

Regards,

Frank

 

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hengqiiiiii Frequent Visitor
Frequent Visitor

Re: Specific Text Reference in PowerBI

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