User Profile
Sonu88
Frequent Visitor
Joined 2 years ago
User Widgets
Contributions
Which table structure is most efficient for Power BI
We are designing a Fact table for use in Power BI and need guidance on the best approach for handling large datasets. Should we opt for a wide Fact table, where each KPI or metric (such as sales, revenue, etc.) is represented as a separate column, Product ID Region ID Revenue Sales Backlog 1 11 100 200 50 2 22 200 300 60 3 33 300 350 70 or a long Fact table, where each metric is stored as a separate row, please see the below structure? Product ID Region ID KPI Measure 1 11 Revenue 100 1 11 Sales 200 1 11 Backlog 50 2 22 Revenue 200 2 22 Sales 300 2 22 Backlog 60 3 33 Revenue 300 3 33 Sales 350 3 33 Backlog 70 The Fact table design should prioritize future scalability, minimal maintenance, and optimal performance within Power BI. The required measures what we are going to show are MTD, QTD, YTD, YOY comparision, 2 years trend etc.Solved1.4KViews0likes6CommentsDisplaying Formatted Text in Matrix/Table
Hello, I would like to display formatted text inside a table. How can I achieve this in a matrix or table? The City column contains some information in italics, and the request is to display this information as it is. I've tried multiple workarounds, but I still can't display the information as intended, can someone help me how to achieve this without any custom visual? The input data file is below. Country Name State City India MS Mumbai Financial Capital India Delhi Delhi Country CapitalSolved790Views0likes2CommentsRe: Unable to Apply Grey Color for Inactive Slicer Values Using DAX
Hi Ritaf1983 , The new slicer has button like features where you can set the conditional logic to fill the color based on state but still it is not applying the color. the measure is SelectedCountry = IF ( ISFILTERED(Country[Country]), IF ( SELECTEDVALUE('Country'[Country]) IN VALUES('Country'[Country]), 1, 0 ), 0 )816Views0likes1CommentUnable to Apply Grey Color for Inactive Slicer Values Using DAX
Hello experts, I have a table with two columns: Country and City, and I'm using the Country column as a slicer with multi-selection enabled. Based on the selected countries, the corresponding cities are displayed in a table. By default, the slicer background colors are red for India, blue for the USA, and green for the UK. What I want to achieve is that when I select a specific country in the slicer (for example, India), the background color of the other countries should turn grey, indicating that they are inactive, until I make additional selections. I am encountering difficulties in applying the grey color to inactive slicer values using DAX, especially since I'm using the new slicer in Power BI.Solved851Views0likes4CommentsRe: Power BI: Resetting Child Slicer Selections When Parent Slicer Changes
Hi PijushRoy , but in that case user has to click the reset button each time before they go for new selection. Is there any way where it should be automatcially whenever user select the parent slicer?1.6KViews0likes4CommentsPower BI: Resetting Child Slicer Selections When Parent Slicer Changes
Hi Experts, I'm facing a tricky issue that I haven't been able to solve. I have two slicers: the parent slicer contains values A, B, and C, while the child slicer has values A1, A2, A3, B1, B2, C1, and C2. When I select a value from the parent slicer, for example, A, the corresponding options in the child slicer (A1, A2, and A3) are correctly filtered. However, what I need is that whenever a new selection is made in the parent slicer, any previous selections in the child slicer are automatically reset before applying the new filter. Any suggestions on how to achieve this? Thanks!1.6KViews0likes7Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.