I needed to quickly create a calculation that tested for the presence of a string in another column's text values. There are two ways to solve this, but the first one is an interesting example that you can use in several situations. This solution plays on the true-false values of the DAX IF function in PowerBI.
Posts tagged ‘PowerBI’
How do I make it easy for the end user to move the source Excel File around while making it easy to update the source location in PowerBI? Query Parameters solved that issue making the solution a lot easier to maintain.
Update: This issue has been corrected with the August 2017 update release.
One of the must-have features I have been desperate to see in PowerBI is the ability to have word wrap in tables. The June 2017 Update, released on July 3, has updated Table and Matrix visualizations which include a number of new features. A detailed list of features are listed on the PowerBI documentation site, PowerBI Desktop Matrix Visual.
With these features being released, I had a client send me an email concerning an issue they were facing.
As you see pictured below, the 3 dots of “More” options now has “Sort By” functionality for each column in the table. My client created a table that has more columns than can be shown on the fly out. This pushes the export data to the bottom without the ability to scroll to get to the export data option.
I have looked into it and cannot, at this point, find a way to get to the export data option when there are many columns in the table. I told them to use the older version of the table from the May 2017 PowerBI Desktop version. For the time being, this has them fine and is the only workaround I have found.
I am certain this will be fixed, however, if you have a large table and use the export data feature, beware.