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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

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
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.