Preserve conditional formatting on export data to excel .xlsx file via Service. At the least preserve fields conditionally formatted as WebURL.
If the chosen tab name can be obtained, then conditional formatting for buttons can be made MUCH simpler.
It would be great to freeze a selected amount columns on a table like you can do in excel! I have a table with many columns and I cant reference values after I have slid past them.
For report pages with multiple visuals with the same axis data (e.g. a clustered bar chart with store locations in the axis field), the ability to sync the vertical/horizontal scrolling on both visuals would greatly improve the ease of use and readability of the report.
Enable line chart data colors to based off of a column in a dataset that has color hex codes. If the legend field of the chart has many values (such as product rank within a group concatenated with product name), hex codes could be repeated for each rank across the various product groups.
We have our reporting database in SingleStore (previously MemSQL) and we would need a native SingleStore connector in Power BI to use it for bigger datasets in direct query mode. It will be great if Microsoft can work with SingleStore and make this native connector available.
The goal of this idea is to enable the ability to navigate to different drill through pages from a drill through destination page. For Example, let's consider a report page that lists the orders of a shop, we can already create a drill through page that shows some details of a single order using ...
One of the drawbacks of using calculation groups is that you may be unable to apply conditional formatting by measures. For example, you cannot apply conditional format to a YoY measure. To do so, it will be necessary to create independent measures outside the calculation group.
To create weeknumbers in DAX we use the DAX function WEEKNUM. The standard system it uses is the US system. To get the correct the correct weeknumber according to ISO 8601. Which is used is Europe, parts of Asia and Australia and many other countries. We now have to choose a return type. WEEKNU...