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

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)