Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
actual result
desired result
i need dynamic index column on the visual based on price column (price column should be in ascending order)
Hi @yaparlasreenath ,
You could also use countrows() function.
column:
Measure:
Best Regards,
Jay
Hi jayw ,
I don't need index numbers based backend whole dataset, i need dynamic index for example
if i apply any filter the index value is recalculate
Hi @yaparlasreenath ,
If you are going to create a column, it will not be dynamically indexing the records based on your selections.
The Only way to get dynamic nature to your index values is by creating measures.
You can check out the below two sugesstions on this
https://community.powerbi.com/t5/Desktop/I-need-to-create-index-column-on-the-visual/m-p/2465967#
https://community.powerbi.com/t5/Desktop/I-need-to-create-index-column-on-the-visual/m-p/2465967#
Regards,
In addition the @Thejeswar you could also use the Mythical DAX Index. The Mythical DAX Index - Microsoft Power BI Community
Hi @yaparlasreenath ,
You need to create a Rank based on the Price and Use this Rank Measure as your index column in the visual.
Hi tejeswar , when i try to implement the same logi i got below error.
A single value for column 'Final Unit price with zeros' in table 'udm_sales_fact' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggr
Hi @yaparedd ,
It clearly tells you what the error is!!
In a measure you have to use aggregate for a column. Like SUM(Table[Price]).
May be you can try this
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |