Forum Discussion

saramason's avatar
saramason
New Member
3 years ago
Solved

Link/Show a Specific table cell in a text box or Card.

Hi, Im fairly new to power bi.

i Have a Image of a tree with some leaves...  The leaves are currently just blank text boxes. (Open to change)

 

What i am trying to do is each individual leaf update with a specific cell text from my data table 

So for example

Leaf 1 = Column 2 Row 1

Leaf 2 = Column 2 Row 2

Leaf 2 = Column 2 Row 3

 

These leafs will always refer to the that specific cell.

The data is always in the same column.

 

I have tried the filter funtion but it only shows first or last row data.

So each week the tree (The leafs) will auto refresh with the new data from the excell workbook connected. (I have done this part)

Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi saramason ,

    According to your description, here's my solution.

    Sample:

    Create three new queries.

    let
    Source = #"Table"[Column1]{0}
in
    Source
    let
    Source = #"Table"[Column1]{1}
in
    Source
    let
    Source = #"Table"[Column1]{2}
in
    Source

    Put the columns in seperate card visuals, get the result:

    I attach my sample below for your reference.

     

    Best regards,

    Community Support Team_yanjiang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • BA_Pete's avatar
    BA_Pete
    Icon for Super User rankSuper User
    3 years ago

    Hi saramason ,

     

    This looks like an XY Problem to me.

    Can you provide more detail around your data and its structure (sceenshots/examples if possible), what the data signifies, how it's calculated (i.e. can we replicate the leaves separately), and what you're actually trying to achieve overall please?

     

    Pete

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi saramason ,

    According to your description, here's my solution.

    Sample:

    Create three new queries.

    let
    Source = #"Table"[Column1]{0}
in
    Source
    let
    Source = #"Table"[Column1]{1}
in
    Source
    let
    Source = #"Table"[Column1]{2}
in
    Source

    Put the columns in seperate card visuals, get the result:

    I attach my sample below for your reference.

     

    Best regards,

    Community Support Team_yanjiang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.