Use KPI card to filter table on same page

[Anonymous]

I have a table and some KPI cards on the left

		City Table
Mumbai		Car Model	City	Price	Available
4		abc1	Mumbai	65251	Y
		abc2	Hyderabad	79208	N
		abc3	Delhi	43448	Y
		abc4	Hyderabad	40501	N
Hyderabad		abc5	Mumbai	95521	Y
3		abc6	Delhi	38443	Y
		abc7	Delhi	33255	N
		abc8	Mumbai	12188	N
Delhi		abc9	Mumbai	53398	Y
3		abc10	Hyderabad	24391	Y

All Im trying to do is, click on the KPI from the left and the table on right would filter the city.

I know KPIs cannot be used for fitlers and drill throughs.

I also tried to place a bar chart on top of these KPI charts but then I wasn't able to make them transparent in color from the Data Colors (that could have solved my problem)

Please suggest 

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

If you want to make the bar chart transparent in color from the Data Colors, you should first create a measure.

BarColour = "#FFFFFF00"

Then make the following choices:

Power BI — KPI or card of visual selectable https://community.powerbi.com/t5/Desktop/KPI-or-card-of-visual-selectable/m-p/1484256

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Winniz,

@v-kkf-msft 

The data colors on the format option of a bar chart doesn't show an FX (conditional color) icon.

Can you help with the same?

[v-kkf-msft]

Hi @Anonymous ,

This post will solve your problem.
Power BI — Conditional Formatting on Bar Chart Solved: Conditional Formatting on Bar Chart - does not wor... - Microsoft Power BI Community

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-kkf-msft I dont see the 3 dots on my data colors format option

[v-kkf-msft]

Hi @Anonymous ,

If you don't see the 3 dots on your data colors format option, can you see the icon in the red circle? Select it and set the color.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.