Friday, 4 September 2015

Hiding Abc

Hi Gurus,
Let us see how to hide "Abc" After dragging and dropping any dimension into the rows/columns shelf in the following steps


Step1:-
1.Open Tableau Desktop and connect to the super store English(Extract)


Step2:-
2. Drag the continent and drop into the Rows.



Step3:-
Go the Analysis Tab and click Create a Calculated Field.


Step4:-
Enter the Field name as Hiding Abc and in the formula window write as CHAR(32) and click on ok.
Note:-
32 is the ASCII Number for the Space.


Step5:-
After that Drag the Hiding Abc field from the Dimensions and drop it into the Label of the Marks Legend,It will replace Abc with space,hence Abc is hided.


Thanks Guru's,
Prazval.ks



DAX Time Intelligence Functions

   Thanks Guru's, Prazval.Ks