Forum Discussion
Continued ContributorRelationships between Parameters and empirical data
Link to PBIX file below.
Hopefully, my nomenclature will be clear. I have one data table with empirical data that has a column, [LRF] with values of 0.875%, 1.0%, 1.125%, 1.25%, 1.375%, and 1.50%
I have a second table that is essentially a What-If Parameter table with all of the individual figures within the range of 0.875% - 1.500% to the third percentage decimal place.
If I leave these two tables unlinked, Power BI views each of these columns as numbers.
When I create a relationship between them, the icon indicating Power BI recognizes the columns as numbers goes away.
The slicers that I want to use the Parameter data for feed into two different visuals - one is a line graph, and the other will be a measure. If the relationship is active, then as soon as I slice the data, blanks get returned.
If I change the slicer to the non-Parameter table, then the measure I want can't be used.
Am I doing something wrong with the relationship linking?
PBIX link: https://drive.google.com/file/d/1KZ03aEOJI1F4Wvg4da8XY_JmxTsA8UB7/view?usp=sharing
Thanks!
1 Reply
Hi mrothschild ，
Please check whether you hit any following limitation of numeric range slicer:
- The numeric range slicer filters every underlying row in the data, not any aggregated value. For example, let's say that you use a Sales Amount field. The slicer then filters each transaction based on the sales amount, not the sum of the sales amount for each data point of a visual.
- It doesn't currently work with measures.
- You can type any number into a numeric slicer, even if it is outside the range of values in the underlying column. This option lets you set up filters if you know the data may change in future.
Best Regards
