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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.