cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
aleph_heideger Frequent Visitor
Frequent Visitor

Re: Filtering data in table visual

@Greg_Deckler

 

Well, Your second solution works perfectly for what I want.

 

Only (minor) problem is that outputs all data in a single line, ID's separated by a comma sign. But like I said, a diferent problem for later - output a real table.

 

Next step is trying to understand your code so I can at least learn something from you.

 

Thanks.

Super User
Super User

Re: Filtering data in table visual

I posted a simplified version here that only has the necessary elements so that other people can study it:

 

https://community.powerbi.com/t5/Quick-Measures-Gallery/Patient-Cohort/m-p/391883

 

You could use the same code and just return the "tmpTable3" (RETURN tmpTable3) and use that as a Table formula. However, it is not dynamic. 😞

 

Maybe one day we will get a Table visualization that you can tie a dynamic table to, that would be really cool. I don't think that exists as a custom visual that I have found, but might be worth checking into. Then you could just do an export. 

 

I did solve this once so that you could generate a dynamic table visualization from the source table. But it used an user input table and some filtering. If I get a chance I'll try to dig it up as an example. Problem was that it solved being able to easily export but wasn't nearly as nice of a user interface and took some setup.

 

I posted this as an Idea here:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33890335-table-visualization-tied...

 


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

aleph_heideger Frequent Visitor
Frequent Visitor

Re: Filtering data in table visual

@Greg_Deckler

 

Isn't it possible to create a table using something like this?

https://community.powerbi.com/t5/Desktop/table-with-dynamic-values-columns/td-p/110266/highlight/tru...

 

I'm not at my computer right now so can't test it but it appears something in the right direction: showing in a table visual filtered results.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,106)