Table visualization & Hyperlinks

[andi2333]

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!!

[andi2333]

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]

Hi @andi2333 

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

Thanks

[andi2333]

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 · Accepted solution]

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]

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

[PijushRoy]

Hi @andi2333 

In Power Query, please create a Custom Column like

The link should match with your original ticket portal link (Ticket ID is dynamic)

Load the Table and Create Table visual, follow the step
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables?tabs=powerbi... 

If Solve your question, please mark as SOLUTION