Forum Discussion
Delete All Fields From Multiple Visuals At Once
Hello Community,
I am copying large numbers of visuals several times for developing several different KPI's.
Each time I copy & paste a set of 20 visuals, I have to manually click each one and delete the linked fields before adding in the new fields.
Is there a way to wipe out all the fields from multiple visuals at one time?
Regards,
Nathan
6 Replies
You have too many visuals. Use Small Multiples.
Thank you for your response.
However, business requires that all KPI's (of various types & origin locations) be shown together.
And each KPI must show the following 10 values:
- 4 quarter goal values
- 1 year goal value
- 4 quarter actual values
- 1 year actual value
Additionally these KPI's all have different units of measurement: $, acres, %, other etc.
Additionally KPI goals come from an Excel spreadsheet on SharePoint, while actual values come from real data in the Data Warehouse.
For these reasons, I don't know how to present the data in any other way except that every measure gets its own visual.
As a result, I am not sure how to use less visuals and still provide business with what they require.
Also, what do you mean by "Use Small Multiples"?
Regards,
Nathan
Create small multiples in Power BI - Power BI | Microsoft Learn
The more visuals you have on a page the longer it takes for the page to render. Small Multiples help to reduce the number of queries .
Forgive my ignorance as I'm just learning about Small Multiples today.
But in the link you shared, it says, "you can create small multiples on bar, column, line and area charts."
Unfortunately, none of these types of visuals meet the business requirements.
Business requires KPI's in numerical format, presented in a table (or in my case, individual cards which resemble a table).
For example, here are the first 5 KPI's, and I am in the process of creating several more.
As you can see from the screenshot, a bar, column, line or area chart cannot be used.
Per business, it must be a table (or individual card visuals which combine to resemble a table as shown above). In either case, the "Small multiples" field well is not available in the Card or Table visuals.
So unless I am mistaken (which is quite possible), the use of small multiples is not an option for the business requirement.
Still I appreciate your attempt to help me.
Regards,
Nathan
P.S. I noticed the recommendation doesn't actually address the original q. Even if I were only copying 4 or 5 visuals (instead of 20), it would still be amazing if you could delete all the fields from multiple visuals at one time. I'm guessing by your response that there is no way to do this in Power BI.
