Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Substance1001
Frequent Visitor

Dynamic Rows Valeus False

Hi,

I have to create Rows Selection form DAX and Link Relation by Index form table[SalesFact] to table[Rows Selection]

now i can selection slicer to change row but my data is false

How to solve this problem?

Thanks for answer.

 

Need data form A table like B table.

2023-12-25_8-31-10.png

 

5 REPLIES 5
lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Sorry for my problem,

Now i got attachment PBIX file form this comment.

Please advise.

 

https://drive.google.com/file/d/1Gn71DP4OtP1yBYbKCU8AfROHHcF7PaYv/view?usp=sharing 

Thank you for the sample data. Please explain the logic for getting the values in Table B, for example S-002 and A11003

 

You can also see the blue i - always a bad sign.

 

lbendlin_0-1703718598950.png

Putting the customer in the columns is not a great idea. You can avoid the issue by swapping the dimensions.

 

lbendlin_1-1703718671854.png

 

In table B i take row and column from table Salefact, This data is correct but i need to change Row and Column from slicer by custom table(Dax from Pic1) now my data is all the same values.

Sorry, I still don't understand the setup. I hope someone else can help you further.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.