Forum Discussion

Bgcunha's avatar
Bgcunha
Regular Visitor
4 years ago

Treemap with multiple Values not filtering

Hi,   I am working on a data quality report and I have a table with some columns with " Potential Flags" such as "Missing Start Date" that have 1 or 0 values based on formulas. I was able to create...
Need Help
Seanan's avatar
Seanan
Solution Supplier
4 years ago

Hi Bgcunha 

Are these other tables and visuals from different data sources? If so please make sure there is a relationship created between the tables. 
If this is not the issue then please could you share the PBIX report removing any sensitive data.

Bgcunha's avatar
Bgcunha
Regular Visitor
4 years ago

Hi Seanan! 

I really appreciate your help willingness to help and prompt response, although in this case if I remove the sensitive data I end up with nothing. lol

But I will try to explain as best as I can the database.

It is just one table, so no relationships needed. This table has Project data and some calculated columns(SQL) for flags using 1 for True and 0 for False.

 

Project Code | Project Name | Date | State  | Type      | Flag No Date | Flag No State | Flag No Type

123                | Project X        |          | Open |              |         1           |           0           |          1

145                | Project Y        | 08/16|           | Internal |         0           |           1           |          0

167                | Project W       |          |Closed| Internal |         1           |           0           |          0

 

On the visualization I have the treemap with the Columns Flag No Date, Flag No State and Flag No Type in the Values with Sum. Than I have a simple table to display the data with Project Code | Project Name | Date | State  | Type that I wish was filtered when I click on the treemap, but it brings all the data no matter which flag I click.

 

Thank you