Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello my dear community members,
I have a ssas multidimensional cube and I have connected the cube to Power bi desktop. when I bring the measure in values and week num and material planner number in Rows and columns its showing the duplicated data like below.
But when i check these values in SQL base tables they are fine. Does anyone knows why this happening? let me know your inputs and thanks in advance.
@Anonymous Wondering if perhaps you need to do a trim and clean on your data coming in. It's almost as if the Material Planner column has values like "100" and "100 " for example.
If it is the case Power Bi will not show 100 and 100 in different columns @Greg_Deckler
@Anonymous Was just an example. It depends on the non-printing character. For example, if there is a line feed ( ASCII 13) for example at the end, then 100 and 100<lf> will show as different columns in the matrix although the lf will not print in the visual so it will look like 100, 100. See attached PBIX below signature.