Forum Discussion

Nika777's avatar
Nika777
Frequent Visitor
3 years ago
Solved

Display comment based on selection

Dear Power BI User, 

 

please can you help me with my question?

I have a table:

ProjectStartStopComment
A1-Jan-2223-Mar-22Comment A
B25-Jun-2217-Oct-23Comment B
C8-Feb-235-May-23Comment 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

Need Help
  • rajulshah's avatar
    rajulshah
    3 years ago

    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.

3 Replies

  • rajulshah's avatar
    rajulshah
    Resident Rockstar
    3 years ago

    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's avatar
      Nika777
      Frequent Visitor
      3 years ago

      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's avatar
        Nika777
        Frequent Visitor
        3 years ago

        Thank you, I could figure out 🙂