Display comment based on selection

[Nika777]

Dear Power BI User, 

please can you help me with my question?

I have a table:

Project	Start	Stop	Comment
A	1-Jan-22	23-Mar-22	Comment A
B	25-Jun-22	17-Oct-23	Comment B
C	8-Feb-23	5-May-23	Comment C

Projects A, B, C are displayed as bar charts (with respective start and stop dates). I want to get the comment displayed depending on the selected project. E.g. if I select the Project A bar (in the bar chart visual), I want to get Comment A displayed. As the comment text can be lengthy, I want to display the respective comment as a separate text box or table under the bar chart visual.

Is this possible?

Sorry, I am new to Power BI (learning) and might need a step by step help.

Thank you so much for your valuable time to help me

With best regards

Nika

[rajulshah · Accepted solution]

@Nika777 

You can create a measure as follows:

Measure = SELECTEDVALUE ( Table [ Project ] )

And you can display the same in the table or a card, I don't think so you would be able to plot the measure in a text box.

Please let me know if this didn't help.

[Nika777]

Dear Rajulshah,

many thanks for your quick reply. Sorry, that I am such a beginner. Please can you guide me how to implement the Measure formula? Do I need to do this in the Power Query Editor?

Many thanks

Nika

[Nika777]

Thank you, I could figure out 🙂