hakan_winther
11 years agoNew Member
Status:
Needs Votes
Add date table to Azure enterprise content pack
I need a date table in the Azure enterprise content pack to be able to create a line chart by month that is sorted correctly as the month column is sorted as string. (Oct is sorted before September and that makes the line chart missleading)
2 Comments
- fbcideas_migusrNew MemberIn data view, select the Month (name) column. On modeling tab, select the Sort by option and select to sort by Month (number). The issue with that is that if you have January 2016 and 2017 on same chart, it might sort differently. What I did was manually created a lookup table with values 1-12 and their associated month and hid the table. I related the two tables together via Month (number). On main table I created a calculated column that brought back the related month name. I created another new calculated column that concatenated the year and month numbers together (in that order). I then selected the month name column and chose to sort by the new yearmonth column. This makes sure if you have two months from different years together on same visual that it won't lump them together.
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Enhance Power BI with Advanced AI-Powered DAX Optimization and Performance Monitoring
Description I would like to suggest introducing advanced AI-powered DAX optimization and performance monitoring capabilities directly into Power BI. As Power BI solutions become more complex, de...ADABOINA_SAIRAM4 hours agoRegular VisitorNew3Views0likes0CommentsexecuteDaxQueries-like API call with effectiveUserName on SSO-enabled model with Service Principal
Please provide a way for a service principal to execute DAX - with an effective user name - against an SSO-enabled directlake semantic model and get per-user results that respect lakehouse OneLake Se...sean_cochran4 hours agoResolver INew16Views1like1CommentEnable Analyze in Excel Without Build Permissions on Power BI Semantic Models
Description: Currently, Power BI requires users to have Build permissions on a semantic model to use the Analyze in Excel feature. However, this permission also grants users the ability to create new...Anonymous6 hours agoNot applicableNew3.8KViews26likes2Comments