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 filter through some metadata (date, priority, market etc.). Now, depending on the set filter value, I would like to show the valid ticketIDs in a table on my PowerBI dashboard, and ideally, once the PBI user clicks on a particular ticketID, this should link to our internal ticketing tool showing the respective details of the ticket.

 

My two questions:

1. How do I create the measure for the table visualisation?

2. How do I hyperlink the results to our ticket tool?

 

Thanks!!

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

     



6 Replies

  • andi2333's avatar
    andi2333
    Helper I
    2 years ago

    Thanks. I guess this solves my 2nd question, however I am not sure about number 1.

    Based on my large table with ticket#, I created a measure which provides the count of open tickets for the current week.

     
    _openTicketsCurrentWeek =
    VAR _cDate = TODAY()
    RETURN
    CALCULATE(
        DISTINCTCOUNT('Aspen Tickets'[Number]),
        FILTER(
            'Aspen Tickets',
            'Aspen Tickets'[Created(opened_at)]  <= _cDate
            && ('Aspen Tickets'[Closed]) > _cDate || ISBLANK('Aspen Tickets'[Closed])
        )
    )
     
    What I would like to do now is take the ticketIDs from this result and put them into a table visualization. I guess it's super simple, but as mentioned, I am a beginner.
     
    Thanks

     

    • 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.