Forum Discussion

andi2333's avatar
andi2333
Helper I
2 years ago
Solved

Table visualization & Hyperlinks

Hey, I am pretty new to PowerBI and I am using this also as a platform to learn, so I hope you dont mind me asking seemingly basic questions.   I have an excel table with ticket numbers which I can...
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi andi2333 

    If I understood currectly, you have
    State column Closed or Open

    Create a Table and in Filter pane use the State column and filter out the Closed ticket.
    I am sharing one example

     



PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

Hi andi2333 

Please share sample data format (not sensative) and output you want 

Thanks

andi2333's avatar
andi2333
Helper I
2 years ago

Screenshot attached shows a snapshot of my input data.

 

On my PBI dashboard, I will depict a card with the number of currently open tickets.

I also want to have a table below that card which shows a list or table of the "INC" numbers which are currently open. 

Somehow like this:

However here, I just pulled the "Number" attribute into the table which then gives me ALL ticketIDs in my table unfiltered. 

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi andi2333 

    If I understood currectly, you have
    State column Closed or Open

    Create a Table and in Filter pane use the State column and filter out the Closed ticket.
    I am sharing one example

     



    • andi2333's avatar
      andi2333
      Helper I
      2 years ago

      Yeah. To be frank, that was pretty simple. I am embarassed. Thank you very much!!!!