So as the dust settles and everyone calms down, it’s time to move on and get back to what we’re good at! Just in case anyone was worried, we’ll continue to be at the cutting edge of PerformancePoint Services and the MS BI stack as well as looking at SharePoint in more detail.
I thought I’d post this one as it’s come up with a couple of our customers recently and isn’t entirely clear at first glance. When you design an Analytic Chart or Grid in Dashboard Designer by default empty rows/columns (or series on a chart) are shown. If you want them to be hidden when the user first opens the chart/grid then click the browse button at the bottom right of the design pane:
The preview window will appear. Now click either of the two end icons on the toolbar (marked by the red rectangle below) to hide the empty rows/columns (or both)
When you click OK the setting will be saved into your design – you can verify this by going into the MDX view of the query and checking that “Non Empty” now appears in your MDX.
You can use the same method to apply sorting by right-clicking on a column in the browse window and selecting the relevant sort function.
Of course if you are using an MDX query then use the NonEmpty/Non Empty functions directly.
As I’ve pointed out before, don’t forget the built-in Dashboard Designer help which is pretty comprehensive
How Artificial Intelligence and Data Add Value to Businesses
Knowledge is power. And the data that you collect in the course of your business
May
Databricks Vs Synapse Spark Pools – What, When and Where?
Databricks or Synapse seems to be the question on everyone’s lips, whether its people asking
1 Comment
May
Power BI to Power AI – Part 2
This post is the second part of a blog series on the AI features of
Apr
Geospatial Sample architecture overview
The first blog ‘Part 1 – Introduction to Geospatial data’ gave an overview into geospatial
Apr
Data Lakehouses for Dummies
When we are thinking about data platforms, there are many different services and architectures that
Apr
Enable Smart Facility Management with Azure Digital Twins
Before I started writing this blog, I went to Google and searched for the keywords
Apr
Migrating On-Prem SSIS workload to Azure
Goal of this blog There can be scenario where organization wants to migrate there existing
Mar
Send B2B data with Azure Logic Apps and Enterprise Integration Pack
After creating an integration account that has partners and agreements, we are ready to create
Mar