Hi: Need help with the below Power BI dashboard issue Issue: In the dashboard I am displaying data in tabular form. But it’s not aggregating the data (key figures) based on the key (dimensions) value. Here is the example I have the below 6 rows in my output Column1---Column2---Column3---Column4 ABC---INDIA---RED---4 ABC---INDIA---GREEN---6 ABC---INDIA---GREEN---2 XYZ---INDIA---RED---5 XYZ---INDIA---RED---8 XYZ---INDIA---RED---2 The desired output to show in the dashboard is like below ABC---INDIA---RED---4 ABC---INDIA---GREEN---8 XYZ---INDIA---RED---15 Basically numeric values need to be aggregated to the Char Key values. It’s not working for me. Am I missing any setting??? If you can help me technically to fix this, I am willing to pay for your time. Please contact me at [email protected]
3 Comments
- H0wl12New MemberIs column 4 set to Sum in aggregation?
- chass
Impactful Individual
Hello, Unfortunately this forum is for filing bugs. Luckily Marco has an example very similar here: https://social.msdn.microsoft.com/Forums/sharepoint/en-US/ae8973ad-b066-419b-90f3-11e7f225331e/equivalent-of-tsqls-if-exists-in-dax?forum=sqlanalysisservices Thanks, Chuck - fbcideas_migusrNew MemberStatus added:Completed
Recent ideas
Pipeline: Activity-level Run Conditions (No IF Container Required)
We need the ability to add a "Run if" condition directly to every pipeline activity. Like, in each acticity's settings. One of the biggest readability issues in Fabric Pipelines is that conditional ...frithjof_v15 hours agoCommunity ChampionNew22Views2likes1CommentPipeline: New Routing activity as an improvement to IF and Switch
The current If Condition and Switch activities create large nested containers that own all activities inside their branches. These containers make the canvas much harder to read. Instead, add a lig...frithjof_v15 hours agoCommunity ChampionNew9Views0likes1CommentDisable Oracle Bundled Provider by Default or Allow Enterprise Administrative Control
Recent versions of Power BI Desktop enable the Oracle Bundled Provider preview feature by default, which can cause Oracle connectivity issues for organizations that rely on custom Oracle authenticati...ASkelt23 hours agoNew MemberNew9Views0likes0CommentsEnhance Workspace Throttling to Allow Targeted Limits on Individual Workspaces
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } The current workspace throttling design should be enhanced to allow Fabr...kyleleonard1 day agoNew MemberNew28Views5likes0Comments