Show card with text based on slicer pick

[Anonymous]

Hi Power BI enthusiasts,

I'm very new to Power BI, and I want to display an explanation of what the slicer shows.

I'll try to show with pictures to explain what I want.

1. Picture of my slicers and graph

2. Picture of my slicers and graph where i've selected "Queue Full"

What i want is then the text to change accordingly to what I've selected. 

The main data source doesn't contain the explanations so i've imported an additional sheet with the explanations

3.  I've tried to make a relationship with the two sheets, but it doesn't seem to have any impact. (I might not know what I'm doing there)

So what I want is when i select from the slicer which is based of "Errorlogs -> Moreinfo" to show "Sheet 2 -> Forklaring"  in the box left of the graph from picture 1.

I hope my explanation makes sense.

Best Regards,

Mads

[Arul]

@Anonymous ,

If you selected something in slicer, what needs to be shown in the card? Please explain it bit more.

Thanks,

Arul

[Anonymous]

So when i select something in the slicer i want to show text from my Sheet 2 (screenshot below)

So the slicer has the same names as the column1 (Moreinfo) in the sheet above, and i want to show column  2 Forklaring, based on which slicer i choose. 

(EDIT)
To clear up all the data from the graph is from the sheet called "Errorlogs" shown in picture 3, but the text explaining the different types of errors, is from the sheet called "Sheet 2"

[Arul]

@Anonymous ,

Use more info column from sheet 2 instead of more info from  "Errorlogs -> Moreinfo" in slicer.

Thanks,

Arul

[Anonymous]

When i use moreinfo from sheet 2 the slicer becomes blank, which doesn't make sense to me. 

Since it has text in the sheet

[Arul]

@Anonymous ,

try this once,

Use more info column from sheet 2 instead of more info from  "Errorlogs -> Moreinfo" in slicer.

Thanks,

Arul

[Shishir22]

Hello @Anonymous ,

Try creating measure as below and use it in card.

MEASURE = FIRSTNONBLANK(Sheet2[Forklaring],0)

Please mark it as answer if it solves your issue. Kudos are also aprreciated.

[Anonymous]

Do i create the measure in Errorlogs or Sheet 2? 

[Shishir22 · Accepted solution]

You can create in any table. Measure is irrespective of table.

Please follow below post.

Hello @Anonymous ,

Try creating measure as below and use it in card. Also change the relationship to both Direction.

MEASURE = FIRSTNONBLANK(Sheet2[Forklaring],0)

Please mark it as answer if it solves your issue. Kudos are also aprreciated.

[Anonymous]

I've changed the relationship to both, and created the measure. (See picture)

Now it just says (Blank) in the field. 

I've dragged the measure to Fields on my card, is this the wrong place?

[Shishir22]

Hello @Anonymous ,

On which column you have given relationships between two tables? Please check relationship is on correct column.

As @Arul, can you please pull More Info column from sheet2 insted of error log?

Please mark it as answer if it resolves your issue. Kudos are also appreciated.

[Anonymous]

I've done like this in the relationship

I've Tried @Arul 's suggestion and posted a reply.

I also want to say thank you so much to the both of you for helping me!

[Shishir22]

Can you please try giving relationship on error code?

[Anonymous]

Like this?

[Shishir22]

Yes please and also make relationship to both direction if you picking value in slicer from error logs table.

[Anonymous]

I've got one last question, now when i haven't chosen anything it shows the text from choice nr. 5 "User Sample...."

Can i get it to display nothing If i haven't selected anything.

[Anonymous]

Yay! It finally works! 
Thank you guys so much. 

You've absolutely made my day! 

[Arul]

@Anonymous ,

It should work as per this relationship between tables.

Thanks,

Arul

[Anonymous]

Probably just me doing something wrong. I started using PowerBI two days ago. 🙂