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
Add a Native Option to Distinguish "No Selection" from "Select All" in Slicers
Summary Today, Power BI slicers treat “Select All” and “No Selection” as equivalent filtering states. While this behavior is technically efficient, it is often unintuitive for report consumers. M...ealco-mc2 hours agoNew MemberNew3Views0likes0CommentsHybrid appearance: Dark mode UI with light/white Data (Table) view grid
Summary Power BI Desktop Dark mode applies to the entire application, including Table/Data view. Report themes can style visuals on the report canvas, but they do not change the Data view grid. Ther...Aryadne_Rocha6 hours agoNew MemberNew5Views0likes0CommentsRoll back a report through the deployment pipeline without effecting any artifacts in both stages.
Let's consider environment of three stages: DEV → UAT → PROD A report was accidentally published directly to PROD, bypassing the deployment pipeline. The report has already been distributed to s...v-viputta16 hours agoMicrosoft EmployeeNew27Views9likes0CommentsSubscribe hidden page / subscribe to a bookmark
today you can not send email remainders (subscribe) pages that are hidden. sometimes you hide pages so you can access them through bookmark but you don't want them to show in the general view. but ...eitanl7 hours agoNew MemberNeeds Votes1.1KViews96likes11CommentsFeature Request: Search functionality in Power Query Queries pane
Power Query becomes increasingly difficult to navigate as the number of queries grows. In real-world Power BI projects, it is common to have 50, 100, or even 200+ queries across multiple folders or g...AbhishekDA17 hours agoNew MemberNew12Views1like0Comments