Forum Discussion
Impactful IndividualDelete All Fields From Multiple Visuals At Once
Impactful Individual
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
Super UserCreate 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 .
- WinterMist
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.
- lbendlin
You can consider using two table visuals. Whatever helps to reduce the number of queries.
Remember there are two pain areas - your pain as a developer, and the pain of the person waiting for your report to render. Their pain is more important than yours.
- WinterMist
I have now added the majority of the visuals (in the same non-recommended way). For whatever reason, the report takes less than a fraction of a second to render. So there actually is no pain...at least currently. Not sure why it's not having problems as you say it should.
Regardless, I still don't comprehend how using any tables at all is an option.
Tables only allow you to add a single measure to each column.
But I need to add many measures to every column since every single card visual is using a unique measure calculation.
So as far as I can tell, it's got nothing to do with one pain vs another pain, but rather with what is possible or not possible.
Regards,
Nathan
P.S. I see you are still not responding to the original question in the post. I now interpret this is a solid "no". Power BI does not have the capability of removing all fields from multiple selected visuals at one time.