Forum Discussion

Lavishnu's avatar
Lavishnu
Frequent Visitor
2 years ago
Solved

Dynamic row count on the visual dependent on field parameter values

Hi All,   I have a Table visual on my dashboard, the columns/fields using a field parameter to select columns dynamically in table visual. The number of rows changes dynamically dependent on user ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Lavishnu 

    Please try this:

    First of all, I create a set of sample:

     

    Home > transform data

    If you want to save the original table, right-click the table and click reference:

     

    All select the columns and click the Unpivot Columns.

     

     

    Apply&Close.

    Add a measure:

    Measure 3 = COUNTROWS('Table (2)')

    The result is as follow:

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Lavishnu's avatar
Lavishnu
Frequent Visitor
2 years ago

Daniel29195 

 

In my scenario i have 20 columns the user can pick max 5 combination of values in field parameters.

Columns: Customers, Products, Category, Units, Levels, InStock etc 
Example: 
If Count when products selected alone
If Counts when products & customer where selected
If counts any columns selected where need summary count which ever values selected

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Lavishnu 

Please try this:

First of all, I create a set of sample:

 

Home > transform data

If you want to save the original table, right-click the table and click reference:

 

All select the columns and click the Unpivot Columns.

 

 

Apply&Close.

Add a measure:

Measure 3 = COUNTROWS('Table (2)')

The result is as follow:

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.