cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.

Highlighted
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 Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)